--- 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