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: (view raw or whole thread)
Lists: pgsql-sql


postgres version:

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:  invalid input syntax for type inet:

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


12    266 fe80::104d:416e:a8dc:c02e/128


May the last 8 was removed and therefore the ip became illegal ? 


Need your help 




Yuval Sofer
BMC Software
CTM&D Business Unit

DBA Team



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-2015 The PostgreSQL Global Development Group