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
pg_ctlcluste With the --force option the "fast" mode is used which rolls
back all active transactions, disconnects clients immediately and thus shuts
down cleanly. If that does not work, shutdown is attempted again in
"immediate" mode, which can leave the cluster in an inconsistent state and
thus will lead to a recovery run at the next start.
View this message in context: http://postgresql.1045698.n5.nabble.com/pg-stat-all-tables-column-value-reseting-problem-tp3767851p4062822.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
In response to
pgsql-admin by date
|Next:||From: jonathan ferguson||Date: 2011-03-20 20:54:39|
|Subject: Re: Hot-standby/Reporting database.|
|Previous:||From: John P Weatherman||Date: 2011-03-18 21:25:44|
|Subject: Hot-standby/Reporting database.|