Tony Caduto wrote: > Hi, > Does anyone know if there is a way to get the backends IP address from > the PID? > I am using the view pg_stat_activity and it would be nice if it would > also display the IP address along with the PID. > > I can see the IP address when I do a ps -ef but it would be nice to be > able to get it via a sql command. Added to TODO: * Add IP address to pg_stat_activity -- Bruce Momjian | http://candle.pha.pa.us pgman@xxxxxxxxxxxxxxxx | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
