pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
vacuum to cleanup transaction wrap around
2+ messages / 2 participants
[nested] [flat]

* vacuum to cleanup transaction wrap around
@ 2007-03-23 14:55 Warren Little <warren.little@meridiascapital.com>
  2007-03-23 15:18 ` Re: vacuum to cleanup transaction wrap around Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 2+ messages in thread

From: Warren Little @ 2007-03-23 14:55 UTC (permalink / raw)
  To: pgsql-admin

All,
have a cluster that hit the wrap-around issue.
We are trying to run the backend vacuum as describe in the manual to  
clear up the problem.

I not sure how I should be interrupting the messages I'm receiving  
from the vacuum command.
Here is the approach I take so far (note pg 8.1.4 Linux 64bit)
from command line  run postgres dbname
at the backend prompt run vacuum
the console spits out the following repeated many times
2007-03-23 08:51:00 MDTWARNING:  database "preR14" must be vacuumed  
within 999134 transactions
2007-03-23 08:51:00 MDTHINT:  To avoid a database shutdown, execute a  
full-database VACUUM in "preR14".

There are a few databases in this cluster ( about 6)

Any suggestions would be greatly appreciated.


Warren Little
Chief Technology Officer
Meridias Capital Inc
ph 866.369.7763

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: vacuum to cleanup transaction wrap around
  2007-03-23 14:55 vacuum to cleanup transaction wrap around Warren Little <warren.little@meridiascapital.com>
@ 2007-03-23 15:18 ` Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2007-03-23 15:18 UTC (permalink / raw)
  To: Warren Little <warren.little@meridiascapital.com>; +Cc: pgsql-admin

Warren Little <warren.little@meridiascapital.com> writes:
> I not sure how I should be interrupting the messages I'm receiving  
> from the vacuum command.

Just do the vacuums.  It's deliberately very noisy about impending
wraparound shutdown, to make sure you notice before it's too late.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2007-03-23 15:18 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-03-23 14:55 vacuum to cleanup transaction wrap around Warren Little <warren.little@meridiascapital.com>
2007-03-23 15:18 ` Tom Lane <tgl@sss.pgh.pa.us>

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