> -----Original Message----- > From: pgsql-admin-owner@xxxxxxxxxxxxxx [mailto:pgsql-admin- > owner@xxxxxxxxxxxxxx] On Behalf Of leslie samuel > Sent: Saturday, March 19, 2011 8:49 AM > To: pgsql-admin@xxxxxxxxxxxxxx > Subject: Re: pg_stat_all_tables column value reseting problem. > > 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 > 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. Check your DB logs. If you are going through recovery on startup, that is your answer. Brad. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin