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

Re: Please HELP - URGENT - transaction wraparound error

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: John Sidney-Woollett <johnsw(at)wardbrook(dot)com>
Cc: Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>,pgsql-general(at)postgresql(dot)org
Subject: Re: Please HELP - URGENT - transaction wraparound error
Date: 2005-10-31 18:46:08
Message-ID: 20051031184605.GJ17694@svana.org (view raw or flat)
Thread:
Lists: pgsql-general
On Mon, Oct 31, 2005 at 05:27:15PM -0000, John Sidney-Woollett wrote:
> > Wonder if it would be a good idea for the error messages to identify which
> > databases might have lost data.
> >
> > However if you have a fair number of databases involved you might get a
> > fair number of log messages. Still, I think I wouldn't mind 100 lines in
> > the logs if I had 100 databases at risk...

FWIW, the 8.1beta has the following code:

                ereport(WARNING,
                   (errmsg("database \"%s\" must be vacuumed within %u transactions",
                                   NameStr(oldest_datname),
                                   (MaxTransactionId >> 1) - age),
                        errhint("To avoid a database shutdown, execute a full-database VACUUM in \"%s\".",
                                        NameStr(oldest_datname))));


Should be enough I think...

-- 
Martijn van Oosterhout   <kleptog(at)svana(dot)org>   http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.

In response to

pgsql-general by date

Next:From: Simon RiggsDate: 2005-10-31 18:58:22
Subject: Re: Starting PostgreSQL 8.0.4 with more memory [FreeBSD
Previous:From: Steve CrawfordDate: 2005-10-31 18:43:40
Subject: Re: Installation trouble

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