Re: How to implement autostart of postgres? - Mailing list pgsql-general

From Tom Lane
Subject Re: How to implement autostart of postgres?
Date
Msg-id 25507.1311259257@sss.pgh.pa.us
Whole thread Raw
In response to How to implement autostart of postgres?  ("Gavrina, Irina" <igavrina@mera.ru>)
List pgsql-general
"Gavrina, Irina" <igavrina@mera.ru> writes:
> I've faced with the following problem: I'm trying to implement the auto
> start of postgres. My way is to use inittab:
> pg:2345:respawn:/bin/su - postgres -c "/usr/local/pgsql/bin/postmaster
> -D/usr/local/pgsql/data >> /usr/local/pgsql/server.log 2>&1" /dev/null
> But this approach does not work as I wished in case of the postmaster
> process dies - it can not be restarted until all child processes are
> stopped. And I have to do it manually.

If the postmaster is dying often enough that this is a serious concern,
you have problems you need to fix.  If this is Linux, maybe you need
to prevent the OOM killer from touching the postmaster?

            regards, tom lane

pgsql-general by date:

Previous
From: Rebecca Clarke
Date:
Subject: Re: Error creating function
Next
From: Mike Blackwell
Date:
Subject: SQL-ASCII database cleanup