Re: Postgresql goes down need to restart (redhat postgresql service script) lock files removal avoid 2 postmasters - Mailing list pgsql-admin

On Thu, May 08, 2003 at 12:50:49 -0400,
  mlaks <mlaks@bellatlantic.net> wrote:
>
> My goal is to use   DJ Bernsteins daemonstools to make sure that my Postgresql
> process goes back up unattended if it goes down for some reason. So I will be
> substituting daemontools for the postgresql service script.
> Thus I want to know what lock files to remove to make sure all is ok. I also
> want to follow Tom Lanes's advice and not shoot myself in the foot by
> creating two different postmaster processes working the same database!!!!

This is what I put in my run file:
#!/bin/sh
exec 2>&1
exec setuidgid postgres /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data

I use multilog for logging as you normally would.