Hello,
I have two different postgresql servers running slightly versions. On one
them, if I try to use pg_stat_activity to get the current queries, I get
1$ psql
psql (9.0.13)
Type help for help.
postgres=# select procpid, query_start, waiting, current_query from
pg_stat_activity;
procpid |
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Si Chen
Sent: Monday, March 31, 2014 2:57 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] getting the current query from pg_stat_activity
Hello,
I have two different postgresql servers
Si Chen-2 wrote
I have two different postgresql servers running slightly [different]
versions.
Versions 9.0 and 9.2 are NOT slightly different. These are two MAJOR
RELEASES (which allow for API changes) apart (i.e., one major release in
between - 9.1)
The release notes for 9.2 note this
Thanks! That's very helpful and answers my question.
On Mon, Mar 31, 2014 at 12:52 PM, David Johnston pol...@yahoo.com wrote:
Si Chen-2 wrote
I have two different postgresql servers running slightly [different]
versions.
Versions 9.0 and 9.2 are NOT slightly different. These are two