pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: leslie samuel <leslie.bks@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: pg_stat_all_tables column value reseting problem.
Date: Sat, 19 Mar 2011 05:49:18 -0700 (PDT)
Message-ID: <1300538958039-4062822.post@n5.nabble.com> (raw)
In-Reply-To: <2626AEE4839D064CB0472A3814DC403F46D20812BE@GVW1092EXB.americas.hpqcorp.net>
References: <1300262337849-3767851.post@n5.nabble.com>
	<AANLkTins9v14V3zmjs_4Z=_z-9EJhK5zBq4BXqi2dFXG@mail.gmail.com>
	<1300425402963-3933652.post@n5.nabble.com>
	<2626AEE4839D064CB0472A3814DC403F46D20812BE@GVW1092EXB.americas.hpqcorp.net>

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-tp3767851p4...
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.



view thread (6+ messages)  latest in thread

Message-ID: <1300538958039-4062822.post@n5.nabble.com>
Permalink:  ../1300538958039-4062822.post@n5.nabble.com/
Also on:    postgresql.org/message-id/1300538958039-4062822.post@n5.nabble.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: leslie.bks@gmail.com
  Subject: Re: pg_stat_all_tables column value reseting problem.
  In-Reply-To: <1300538958039-4062822.post@n5.nabble.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox