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
