Re: How to check postgres running or not ?

Assuming it is unix....  The command

ps xau|grep post

If it is running it will produce output like...

worik@stolberg:~$ ps xau|grep post
postgres   880  0.0  0.2  8580  740 ?        S    Sep07   0:31 
/usr/lib/postgresql/bin/postmaster
postgres   887  0.0  0.2  9536  612 ?        S    Sep07   0:02 postgres: 
stats buffer process
postgres   889  0.0  0.2  8624  632 ?        S    Sep07   0:05 postgres: 
stats collector process
worik    25927  0.0  0.2  1612  540 pts/10   S    13:54   0:00 grep post
worik@stolberg:~$

If it is not running it will produce output like...

worik@stolberg:~$ ps xau|grep post
worik    26094  0.0  0.2  1608  528 pts/10   S    13:55   0:00 grep post


Sandeep Gaikwad wrote:
> 
> 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 ?
> 
> Thanks and regards,
> Sandeep.
> 
> 
> ------------------------------------------------------------------------
> 
> ---------------------------------------------------------
> 
> Disclaimer:
> 
> The contents of this message are confidential and intended to the addressee at the specified e-mail address only. Its
contentsmay not be copied or disclosed to anyone other than the intended recipient. If this e-mail is received in
error,please contact Vertex Software Pvt. Ltd immediately on +91 20 4041500  with details of the sender and addressee
anddelete the e-mail. Vertex Software Pvt. Ltd accepts no responsibility in the event that the onward transmission,
openingor use of this message and/or any attachments adversely affects the recipient's systems or data. It is the
recipient'sresponsibility to carry out such virus and other checks as the recipient considers appropriate.
 
> 
> ---------------------------------------------------------
> 
> 
> ------------------------------------------------------------------------
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings