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?