Re: Checking whether postgresql is running

Ennio-Sr wrote:

> [Possible duplicate: original sent to novice never got through! -;(]
> Hi all!
> Testing a script where I need to make sure that postgresql is running
> before passing a <psql dbasename -c "insert into ..." > instruction I
> faced this curious behaviour:
>
> This is the relevant content of the script:
> ------------------
> #!/bin/bash
> /usr/lib/postgresql/bin/pg_ctl status -D /var/lib/postgres/data >/dev/null 2>&1
> rtn=$?
> if [ $rtn -ne 0 ]; then
> echo "not running"
> else
> echo "ok ok"
> fi
>
> Now, if I run the script as root, I get:
>
> ok ok
>
> (or, commenting the script if condition:
> pg_ctl: postmaster is running (pid: 18658)
> Command line was:
> /usr/lib/postgresql/bin/postmasteir)
>
> whereas, if I run the same script as ordinary user, the answer is:
>
> not running
>
> (or, commenting the if lines:
> pg_ctl: postmaster or postgres is not running)
>
> --------------
> Everything is being tested on the same PC [running PG 7.2.1-2Woody5
> under GNU/Linux, k. 2.2.22], root being on /dev/tty1, user on
> /dev/tty2, and postgresql not being stopped while switching from root
> to user :-).
> Could anybody throw some light on this issue?

Though I don't read Perl at all, so I haven't the
slightest idea about what's in the if, I think I
can shed some light on the issue...

When you execute pg_ctl -D /var/lib/postgres/data,
the command fails -- you can not access the directory
/var/lib/postgres/data to go and pickup the file
postgres.pid (I think that's the filename) to check
if that PID is running. So, without understanding
that gibberish inside the if, I bet that it simply
is returning some error code that is causing the
"not running" part of the if to be executed.

You have to be user postgres or superuser to be
able to use pg_ctl to verify if postmaster is
running.

A "loose check" would be executing the command
"ps -C postgres" and see if there's any output.

Or, simply use the PG client library -- you will
get an error message saying that postmaster is
not running on the specified port.

Carlos
--