Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 221331337BF8 for ; Sat, 19 Mar 2011 09:49:29 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 90976-03 for ; Sat, 19 Mar 2011 12:49:20 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from sam.nabble.com (sam.nabble.com [216.139.236.26]) by mail.postgresql.org (Postfix) with ESMTP id 9EFB01337BA3 for ; Sat, 19 Mar 2011 09:49:18 -0300 (ADT) Received: from [192.168.236.26] (helo=sam.nabble.com) by sam.nabble.com with esmtp (Exim 4.69) (envelope-from ) id 1Q0vao-0007UU-1U for pgsql-admin@postgresql.org; Sat, 19 Mar 2011 05:49:18 -0700 Date: Sat, 19 Mar 2011 05:49:18 -0700 (PDT) From: leslie samuel To: pgsql-admin@postgresql.org Message-ID: <1300538958039-4062822.post@n5.nabble.com> In-Reply-To: <2626AEE4839D064CB0472A3814DC403F46D20812BE@GVW1092EXB.americas.hpqcorp.net> References: <1300262337849-3767851.post@n5.nabble.com> <1300425402963-3933652.post@n5.nabble.com> <2626AEE4839D064CB0472A3814DC403F46D20812BE@GVW1092EXB.americas.hpqcorp.net> Subject: Re: pg_stat_all_tables column value reseting problem. MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.767 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, T_TO_NO_BRKTS_FREEMAIL=0.01, URI_HEX=1.122 X-Spam-Level: X-Archive-Number: 201103/203 X-Sequence-Number: 37075 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. -- 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.