Skip site navigation (1) Skip section navigation (2)

vacuum to cleanup transaction wrap around

From: Warren Little <warren(dot)little(at)meridiascapital(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: vacuum to cleanup transaction wrap around
Date: 2007-03-23 14:55:35
Message-ID: (view raw or whole thread)
Lists: pgsql-admin
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


pgsql-admin by date

Next:From: Tom LaneDate: 2007-03-23 15:18:03
Subject: Re: vacuum to cleanup transaction wrap around
Previous:From: Bjarni RagnarssonDate: 2007-03-23 13:20:31
Subject: Re: Encoding problems

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group