Re: Checking that Pg is running from a shell script

Hi,

if You have fuser on Your system You can check the process
listening on the postgres port 5432:
fuser -n tcp 5432 | wc -l
returns 1 (a line containing only "1" and whitespace) if there
is a process listening on this port and 0 if is not.
Another choice is to look for a process with the pid from
../data/postmaster.pid (probably the better choice).

-tb


On Mon, Jun 10, 2002 at 10:29:06AM -0400, Fran Fabrizio wrote:
>
> What's the best way to ensure that Pg is running from a shell script?
>  I'm crafting a few RPMs for my projects, one of which will attempt to
> load data into a database, but I want to check that it's running first
> before I try this.
>
> I'm a shell scripting newbie so apologies if the answer is really
> straightforward.  I don't know if UNIX processes leave a standard trail
> so that I could just look up if something is listening on 5432, for
> example.
>
> Thanks,
> Fran
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org

--
Thomas Beutin                             tb@laokoon.IN-Berlin.DE
Beam me up, Scotty. There is no intelligent live down in Redmond.