Re: How to check postgres running or not ?

Perhaps I have a bug in pg_ctrl?

This is what I get...

worik(at)stolberg:~$ 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
worik(at)stolberg:~$

cheers
Worik

Jeff Eckermann wrote:
> --- Christopher Browne <cbbrowne(at)acm(dot)org> wrote:
>
>
>>In an attempt to throw the authorities off his
>>trail, sgaikwad(at)vertex(dot)co(dot)in ("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:
>>
>>cbbrowne(at)wolfe:/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
>>majordomo(at)postgresql(dot)org)
>>
>
>
>
>
>
> _______________________________
> 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
>
>
>