Re: Postgresql, HA ?, Monitoring.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "V(dot) M(dot)" <txian(at)hotmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Postgresql, HA ?, Monitoring.
Date: 2001-04-19 22:01:07
Message-ID: 22799.987717667@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"V. M." <txian(at)hotmail(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Mike Mascari 2001-04-19 22:34:11 Re: System catalog representation of access privileges
Previous Message Tom Lane 2001-04-19 21:53:26 Re: System catalog representation of access privileges