Issue with Postgres process startup after instance restart

Поиск
Список
Период
Сортировка
От Shishir Joshi
Тема Issue with Postgres process startup after instance restart
Дата
Msg-id CACahDtrYrfDtOEuXCHQ-rnk4xv0SvVXBabHMSpwimewW3KUOzQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: Issue with Postgres process startup after instance restart
Список pgsql-general
Hello,
I recently faced an issue with PG 11 where the VM that the PG process was running on got restarted because of a hardware issue. After the VM restart, the Postgres process failed to start on the 1st attempt with the error "LOG:  could not open directory "pg_tblspc/16388/PG_11_201809051": No such file or directory" even though that directory was present. But on the 2nd attempt it started up without issues. There didn't seem to be any disk corruption issues and there were no other errors in the syslog either. Has anyone else faced such an issue or has any ideas on why this could have occurred? 

В списке pgsql-general по дате отправления:

Предыдущее
От: Laurenz Albe
Дата:
Сообщение: Re: How can I recreate a view in a new schema such that the viewdef references tables in the new schema ?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Issue with Postgres process startup after instance restart