Re: need a method to ping a running database

From: "Jay O'Connor" <joconnor(at)cybermesa(dot)com>
To: Travis Hume <travis(dot)hume(at)tenzing(dot)com>, pgsql-general(at)postgresql(dot)org
Cc: Breck Thomas <Breck(dot)Thomas(at)tenzing(dot)com>
Subject: Re: need a method to ping a running database
Date: 2003-06-12 00:07:49
Message-ID: 3.0.1.32.20030611180749.008784f0@cybermesa.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Edmund Dengler 2003-06-12 00:11:02 Performance of a query
Previous Message Maksim Likharev 2003-06-11 23:53:38 Re: TABLE FUNCTION, ERROR: WRONG RECORD TYPE IN RETURN NEXT