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
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 |