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

Reply via email to