Perhaps I have a bug in pg_ctrl?
This is what I get...
[EMAIL PROTECTED]:~$ ps aux | grep postmaster | grep -v grep ;/usr/lib/postgresql/bin/pg_ctl status
postgres 670 0.0 0.6 8544 1688 pts/1 S 12:33 0:00 /usr/lib/postgresql/bin/postmaster
pg_ctl: postmaster or postgres is not running
[EMAIL PROTECTED]:~$
cheers Worik
Jeff Eckermann wrote:
--- Christopher Browne <[EMAIL PROTECTED]> wrote:
In an attempt to throw the authorities off his trail, [EMAIL PROTECTED] ("Sandeep Gaikwad") transmitted:
Hello Sir, I want to know how to check
whether postgres database
is running or not ? when I give command like
./postmaster -i &,
whether all databases in that postgres will run or
any one [default] ?
If any one, then how to detect that database ?
The "standard" way would be "pg_ctl status". "man pg_ctl" is recommended reading for anyone administering a PostgreSQL setup.
Well, the way I usually check on what databases are running is thus:
[EMAIL PROTECTED]:/tmp/mm5/doc> netstat -an | grep PG Saturday 13:18:30
unix 2 [ ACC ] STREAM LISTENING 2793 /var/run/postgresql/.s.PGSQL.5432
One could presumably script things further to get more out of that; it doesn't normally seem worthwhile to do so... -- output = ("cbbrowne" "@" "ntlug.org") http://www.ntlug.org/~cbbrowne/postgresql.html "As long as war is regarded as wicked, it will always have its fascination. When it is looked upon as vulgar, it will cease to be popular." --Oscar Wilde
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
_______________________________ Do you Yahoo!? Declare Yourself - Register online to vote today! http://vote.yahoo.com
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings