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