-Original Message-
From: pgsql-admin-ow...@postgresql.org [mailto:pgsql-admin-
ow...@postgresql.org] On Behalf Of leslie samuel
Sent: Saturday, March 19, 2011 8:49 AM
To: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] pg_stat_all_tables column value reseting problem.
For stop
For stop/Restart the postmaster, I am using pg_ctlcluster --force command.
I have read about pg_ctlcluster in the net they are saying this below
things,
pg_ctlcluste With the --force option the fast mode is used which rolls
back all active transactions, disconnects clients immediately and thus
-Original Message-
From: pgsql-admin-ow...@postgresql.org [mailto:pgsql-admin-
ow...@postgresql.org] On Behalf Of leslie samuel
Sent: Friday, March 18, 2011 1:17 AM
To: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] pg_stat_all_tables column value reseting problem.
Thanks for ur
Thanks for ur reply Ragu..
Yes, I have executed this select pg_stat_reset(); as a root user.
It has reseted the values.
But last time ( when I was posted this query) I didn't executed it.
But values were rested automatically.
I would like to know,
= Whether postgres automatically running
On Wed, Mar 16, 2011 at 1:28 PM, leslie samuel leslie@gmail.com wrote:
Dear friends,
I would like to know the particular table's insert,update and delete
record history.
I have done some googling and got to know about pg_stat_all_tables and
pg_stat_user_tables. These tables having