Re: How to implement autostart of postgres?

"Gavrina, Irina" <igavrina(at)mera(dot)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