| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Stephen Frost <sfrost(at)snowman(dot)net> |
| Cc: | lists(at)benjamindsmith(dot)com, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Postgresql Segfault in 8.1 |
| Date: | 2006-01-25 19:13:08 |
| Message-ID: | 4940.1138216388@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Stephen Frost <sfrost(at)snowman(dot)net> writes:
> * Tom Lane (tgl(at)sss(dot)pgh(dot)pa(dot)us) 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-01-25 19:18:19 | Re: Postgresql Segfault in 8.1 |
| Previous Message | Benjamin Smith | 2006-01-25 19:04:34 | Re: Postgresql Segfault in 8.1 |