Thanks! That's very helpful and answers my question.
On Mon, Mar 31, 2014 at 12:52 PM, David Johnston 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 MAJOR
> RELE
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 par
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
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 |
