Stephen Frost <[EMAIL PROTECTED]> writes:
> * Tom Lane ([EMAIL PROTECTED]) wrote:
>> ps auxww | grep postgres:
>> ... eyeball determination of correct PID ...
> You can also do 'select pg_backend_pid();' from psql... I know that's
> there on 8.1, though I recall this was an 8.0 discussion and I *think*
> it's there too but not 100% sure.
Good thought. I've been doing it via ps since forever, but
pg_backend_pid is more foolproof (and it seems to have been in since
7.3, so that's not a problem).
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
