Re: is there anyway to get the backends IP address from the

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Steve Crawford <scrawford(at)pinpointresearch(dot)com>
Cc: tony(dot)caduto(at)amsoftwaredesign(dot)com, pgsql-general(at)postgresql(dot)org
Subject: Re: is there anyway to get the backends IP address from the
Date: 2005-02-21 18:50:52
Message-ID: 200502211850.j1LIoqw08577@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Steve Crawford wrote:
> On Saturday 12 February 2005 4:09 pm, Bruce Momjian wrote:
> > Added to TODO:
> >
> > * Add IP address to pg_stat_activity
>
> I like it. How about IP and port to differentiate multiple connections
> from the same host? Will this support IPV6?

Good point, added:

* Add the client IP address and port to pg_stat_activity

and yes, it would support IPv6.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Don Doumakes 2005-02-21 18:52:49 Recovering db from cracked server
Previous Message Phil Endecott 2005-02-21 18:45:01 Re: Scalability with large numbers of tables