Re: need a method to ping a running database - Mailing list pgsql-general

From Jay O'Connor
Subject Re: need a method to ping a running database
Date
Msg-id 3.0.1.32.20030611180749.008784f0@cybermesa.com
Whole thread Raw
In response to need a method to ping a running database  (Travis Hume <travis.hume@tenzing.com>)
Responses Re: need a method to ping a running database  (Travis Hume <travis.hume@tenzing.com>)
List pgsql-general
> 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.  This is a bit misleading to say the least.

First thoght is don't do "kill -9" other than the pid problem is the probem
that postgresql caches data in memory and that could be a problem if you
kill like that.  Use pg_ctl stop -m fast or pg_ctl stop -m immediate

Take care,
Jay

pgsql-general by date:

Previous
From: Edmund Dengler
Date:
Subject: Performance of a query
Next
From: Travis Hume
Date:
Subject: Re: need a method to ping a running database