Re: postgresql start/stop/status script

[Baldur Norddahl <bbn-pgsql.general@xxxxxxxxxxx>]

Peter Eisentraut wrote:

Baldur Norddahl wrote:
  

Is there a better way to query the status of postgresql? I would
expect it to at least check that the process in the PID is actually
running and that it is a postgresql process.
    

Maybe try

test $(readlink /proc/$pid/exe) = /usr/bin/postgres
  

I have now changed my script to use this instead:

        if pgrep -U pg0 'postmaster' > /dev/null
        then
                echo running
        else
                echo stopped
        fi

I would still hold that "pg_ctl status" is broken though.

Baldur