Re: How to check postgres running or not ? - Mailing list pgsql-sql

From Gaetano Mendola
Subject Re: How to check postgres running or not ?
Date
Msg-id 414EAB83.3060600@bigfoot.com
Whole thread Raw
In response to Re: How to check postgres running or not ?  (Worik <worik@noggon.com>)
Responses Re: How to check postgres running or not ?  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-sql
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Worik wrote:
|
|
| [snip]
|
|>
|>
|> Just to enforce the test is better looking for the entire executable
|> path:
|>
|>         ps aux | grep /usr/bin/postmaster | grep -v grep
|>
|
| Does not work for me!
|
| worik@stolberg:~$ ps aux | grep /usr/bin/postmaster | grep -v grep
| worik@stolberg:~$ ps aux | grep postmaster | grep -v grep
| postgres   670  0.1  0.6  8544 1688 pts/1    S    12:33   0:00
| /usr/lib/postgresql/bin/postmaster
| worik@stolberg:~$
|
| So...
| " ps aux | grep postmaster | grep -v grep "
| is more reliable(?)

It only depends on your distribution, in your case:


ps aux | grep /usr/lib/postgresql/bin/postmaster | grep -v grep


consider also the if you run different postmaster version in different
location this is the only way I believe



Regards
Gaetano Mendola







-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFBTquC7UpzwH2SGd4RAiouAKCpvuLSspsTVXCjSLgDZ2ZKQ3gfywCg7rzl
gXkPlq9UanBNjIWpBvPXNwo=
=ZNAY
-----END PGP SIGNATURE-----



pgsql-sql by date:

Previous
From: T E Schmitz
Date:
Subject: Re: ORDER BY and NULLs
Next
From: Peter Eisentraut
Date:
Subject: Re: How to check postgres running or not ?