Re: Comfortably check BackendPID with psql - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Comfortably check BackendPID with psql
Date
Msg-id 20150611095556.GB16018@awork2.anarazel.de
Whole thread Raw
In response to Comfortably check BackendPID with psql  (Naoya Anzai <nao-anzai@xc.jp.nec.com>)
Responses Re: Comfortably check BackendPID with psql  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
List pgsql-hackers
Hi,

On 2015-06-11 09:41:17 +0000, Naoya Anzai wrote:
> This is a so tiny patch but I think it is very useful for hackers and DBAs.
> When we debug with psql, we frequently use "SELECT pg_backend_pid();".
> This can change the input of the 24 characters to the only 4 characters!

Not a big fan of that abbreviation itself. What I'd wondered about
instead - and actually had patched into my psql at some point - is
adding an appropriate escape to psql's PROMPT. I think that'd serve your
purpose as well?

Regards,

Andres



pgsql-hackers by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: skipping pg_log in basebackup (was Re: pg_basebackup and pg_stat_tmp directory)
Next
From: Naoya Anzai
Date:
Subject: Re: Comfortably check BackendPID with psql