Postgres Pro
Downloads
Home   >   mailing lists

Thread: PostgreSQL starting with a corrupted database or other fatal issues

PostgreSQL starting with a corrupted database or other fatal issues

From
Keith Christian
Date:
Assuming that PostgreSQL is started by systemd, and encounters fatal
issues, how often does systemd attempt to re-start it before giving
up?

I'm not familiar with that interaction and if systemd stops after X
attempts, or what.

What does postgres do when it encounters fatal issues and cannot
start?  It obviously abandons starting at some point.

Where would I find details about this situation in the PG docs?

THANKS.

Re: PostgreSQL starting with a corrupted database or other fatal issues

From
"David G. Johnston"
Date:
On Friday, September 10, 2021, Keith Christian <keith1christian@gmail.com> wrote:
Where would I find details about this situation in the PG docs?.


As far as PostgreSQL is concerned if startup fails it tries to log that fact then stops.  If doesn’t care whether it’s being started by hand, via systemd, or even cron, and it is out of scope for the server documentation to cover such things.  Whomever wrote the systemd stuff for your O/S platform will hopefully have documented such things, otherwise I would advise to inspect the configuration files themselves.

David J.