From: Worik <worik@noggon.com>
To: Sandeep Gaikwad <sgaikwad@vertex.co.in>
Cc: pgsql-sql@postgresql.org
Subject: Re: How to check postgres running or not ?
Date: Sun, 19 Sep 2004 13:57:02 +1200
Message-ID: <414CE76E.2050405@noggon.com> (raw)
In-Reply-To: <414A7395.8070503@vertex.co.in>
References: <414A7395.8070503@vertex.co.in>
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 contents may 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 and delete the e-mail. Vertex Software Pvt. Ltd accepts no responsibility in the event that the onward transmission, opening or use of this message and/or any attachments adversely affects the recipient's systems or data. It is the recipient's responsibility 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: worik@noggon.com, sgaikwad@vertex.co.in
Subject: Re: How to check postgres running or not ?
In-Reply-To: <414CE76E.2050405@noggon.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox