Re: Postgresql, HA ?, Monitoring. - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Postgresql, HA ?, Monitoring.
Date
Msg-id 22799.987717667@sss.pgh.pa.us
Whole thread Raw
In response to Postgresql, HA ?, Monitoring.  ("V. M." <txian@hotmail.com>)
List pgsql-hackers
"V. M." <txian@hotmail.com> writes:
> DBI->connect(dbname=mydb) failed: Backend startup failed

Have you looked in the postmaster log to see *why* this is happening?
Some sort of resource-limitation problem is my bet.

> I'm asking to all of you the CORRECT sequence of actions to do a monitor 
> that restarts postgresql in the most safe possible way.
> This for having a solution that gives a better overall uptime.

Restarting the postmaster because a backend start failed is certainly
not the way to improve uptime.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: System catalog representation of access privileges
Next
From: Mike Mascari
Date:
Subject: Re: System catalog representation of access privileges