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

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: mlaks <mlaks(at)bellatlantic(dot)net>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Postgresql goes down need to restart (redhat postgresql service script) lock files removal avoid 2 postmasters
Date: 2003-05-08 17:50:21
Message-ID: 20030508175021.GA3335@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Thu, May 08, 2003 at 12:50:49 -0400,
mlaks <mlaks(at)bellatlantic(dot)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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Andrew Sullivan 2003-05-08 18:05:24 Re: The database system is in recovery mode
Previous Message mlaks 2003-05-08 16:50:49 Postgresql goes down need to restart (redhat postgresql service script) lock files removal avoid 2 postmasters