From: Ben Kim <bkim@tamu.edu>
To: Sofer, Yuval <Yuval_Sofer@bmc.com>
Cc: pgsql-admin@postgresql.org, "Abraham, Danny" <danny_abraham@bmc.com>
Subject: Re: problem with pg_stat_activity view
Date: Mon, 8 Sep 2008 08:27:06 -0500 (CDT)
Message-ID: <Pine.GSO.4.64.0809080824320.9078@coe.tamu.edu> (raw)
In-Reply-To: <BE67D1149BBD5746984545ED91F702E001F43035@hou-ex-02.adprod.bmc.com>
References: <BE67D1149BBD5746984545ED91F702E001F43035@hou-ex-02.adprod.bmc.com>
fe80::104d:416e:a8dc:c02e %12
Since %12 is a "space" character, it seems first thing to do might be an
extra space in your code. Just a quick guess.
Regards,
Ben Kim
On Mon, 8 Sep 2008, Sofer, Yuval wrote:
> Hello,
>
>
>
> postgres version: 8.2.0.4
>
> platform windows: server 2008
>
>
>
> I check connections using:
>
>
>
> SELECT pg_stat_get_backend_idset()
>
>
>
> Now, I take the output and try to get the ip addresses using
>
>
>
> select pg_stat_get_backend_client_addr(<integer>);
>
>
>
> but for a local connection (simple login using psql), I get the next
> error:
>
>
>
> ERROR: invalid input syntax for type inet:
> "fe80::104d:416e:a8dc:c02e%12"
>
> SQL state: 22P02
>
>
>
> The same error occurs for simple "select * pg_stat_activity" (of course,
> as it is based on the former function)
>
>
>
> I noticed that for netstat -r -n, I got the next line (among the
> others):
>
>
>
> 12 266 fe80::104d:416e:a8dc:c02e/128
>
>
>
> May the last 8 was removed and therefore the ip became illegal ?
>
>
>
> Need your help
>
>
>
> Thanks,
>
>
>
> Yuval Sofer
> BMC Software
> CTM&D Business Unit
>
> DBA Team
> 972-52-4286-282
> yuval_sofer@bmc.com
>
>
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: bkim@tamu.edu, Yuval_Sofer@bmc.com, danny_abraham@bmc.com
Subject: Re: problem with pg_stat_activity view
In-Reply-To: <Pine.GSO.4.64.0809080824320.9078@coe.tamu.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox