Re: Checking that Pg is running from a shell script

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.

Sure, pg_ctl status:

    $ pg_ctl status
    pg_ctl: postmaster is running (pid: 7340)
    Command line was:
    /usr/var/local/postgres/./bin/postmaster '-o' ''

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026