Stephen Frost <sfrost@xxxxxxxxxxx> writes: > * Tom Lane (tgl@xxxxxxxxxxxxx) 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
