Hello, We have Pg 8.0.x and Pg 8.2.x on 2 separate Linux servers. We have a perl script (perl 5.8.7, DBI-1.48/DBD::Pg-1.49) that connects to each database to determine if there are active connections.with the following query. SELECT count(*) from pg_stat_activity;
The above query always returns 0 rows for Pg 8.0.x and 1 row for Pg 8.2.x. When we connect to the database using psql client, the above query returns 1 row for both the databases. Does anyone has an idea what could be the issue? Is there any other way to determine active connections in the database? Thanks for all the help!
