Re: Postgresql, HA ?, Monitoring.

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: "V. M." <txian@hotmail.com>
Cc: pgsql-hackers@postgresql.org
Date: 2001-04-19T22:01:07Z
Lists: 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