Re: How to implement autostart of postgres?

On 20/07/11 19:02, Gavrina, Irina wrote:
> Hello All,
>
>
>
> 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

Are you working on some kind of embedded platform?

For any modern Linux or UNIX, the init subsystem takes care of this with
init scripts. Newer Linux systems use `upstart' or `systemd' instead of
old-style sysv init; these newer init systems support init "scripts"
that can monitor and re-start processes. See the upstart and systemd
documentation.

If you're trying to re-start the postmaster when it exits, the bigger
question is: why is it exiting? It shouldn't be, and that's what you
need to fix.

Typically you'd just start the postmaster at boot and leave it running.
If you want system self-healing and recovery, there are existing
monitoring solutions like nagios that support running scripts when
certain kinds of failures appear. Be aware, though, that if the
postmaster has exited then something is already wrong, and trying to
just re-start it might mask a problem and prevent you from finding out
about it until it is much worse.

--
Craig Ringer