problem with pg_stat_activity view

From: "Sofer, Yuval" <Yuval_Sofer(at)bmc(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Cc: "Abraham, Danny" <danny_abraham(at)bmc(dot)com>
Subject: problem with pg_stat_activity view
Date: 2008-09-08 11:28:48
Message-ID: BE67D1149BBD5746984545ED91F702E001F43035@hou-ex-02.adprod.bmc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Devrim GÜNDÜZ 2008-09-08 13:14:29 Re: update to 8.3.3
Previous Message Jan-Peter.Seifert 2008-09-08 10:05:27 Re: pg_dump etc. versions