Issue with Postgres process startup after instance restart

From: Shishir Joshi <shishir(dot)joshi(at)gojek(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Issue with Postgres process startup after instance restart
Date: 2020-03-27 11:10:41
Message-ID: CACahDtrYrfDtOEuXCHQ-rnk4xv0SvVXBabHMSpwimewW3KUOzQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2020-03-27 14:00:49 Re: Issue with Postgres process startup after instance restart
Previous Message Laurenz Albe 2020-03-27 09:08:21 Re: How can I recreate a view in a new schema such that the view def references tables in the new schema ?