Re: problem with pg_stat_activity view

From: Ben Kim <bkim(at)tamu(dot)edu>
To: "Sofer, Yuval" <Yuval_Sofer(at)bmc(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org, "Abraham, Danny" <danny_abraham(at)bmc(dot)com>
Subject: Re: problem with pg_stat_activity view
Date: 2008-09-08 13:37:35
Message-ID: Pine.GSO.4.64.0809080833290.9078@coe.tamu.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


Sorry, I apologize for the mistake. %20 is the space, and the extra %12
seems to be DC3 (device control 3).

Regards,

Ben Kim

On Mon, 8 Sep 2008, Ben Kim wrote:

>
> 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(at)bmc(dot)com
>>
>>
>>
>>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Alvaro Herrera 2008-09-08 13:44:39 Re: problem with pg_stat_activity view
Previous Message Ben Kim 2008-09-08 13:27:06 Re: problem with pg_stat_activity view