Skip site navigation (1) Skip section navigation (2)

problem with pg_stat_activity view

From: "Sofer, Yuval" <Yuval_Sofer(at)bmc(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: problem with pg_stat_activity view
Date: 2008-09-08 11:29:50
Message-ID: BE67D1149BBD5746984545ED91F702E001F4303A@hou-ex-02.adprod.bmc.com (view raw or flat)
Thread:
Lists: pgsql-sql
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

pgsql-sql by date

Next:From: Tom LaneDate: 2008-09-08 12:54:04
Subject: Re: problem with pg_stat_activity view
Previous:From: Milen A. RadevDate: 2008-09-08 11:07:24
Subject: Re: psql: FATAL: Ident authentication failed for user "postgres"

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group