Re: need a method to ping a running database

From: Erik Price <eprice(at)ptc(dot)com>
To: Travis Hume <travis(dot)hume(at)tenzing(dot)com>
Cc: pgsql-general(at)postgresql(dot)org, Breck Thomas <Breck(dot)Thomas(at)tenzing(dot)com>
Subject: Re: need a method to ping a running database
Date: 2003-06-12 12:24:04
Message-ID: 3EE870E4.4030103@ptc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Travis Hume wrote:

> to determine if the database had been started. There are a couple of
> problems with this method. It seems that if you start postgresql and
> then issue a "kill -9" on the postmaster processes a .pid file is left
> behind (understandable), but then if you run "pg_ctl status" it will
> immediately report that the database is running and give you the pid
> number and whatever else.

I've seen this message at the bottom of some emails to this list:

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Erik

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jan Wieck 2003-06-12 12:28:44 Re: [HACKERS] SAP and MySQL ... [and Benchmark]
Previous Message Jan Wieck 2003-06-12 12:02:02 Re: [GENERAL] MySQL gets $19.5 MM