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

Reply via email to