Re: postgresql start/stop/status script

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