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:
(errmsg("database \"%s\" must be vacuumed within %u transactions",
(MaxTransactionId >> 1) - age),
errhint("To avoid a database shutdown, execute a full-database VACUUM in \"%s\".",
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 Riggs||Date: 2005-10-31 18:58:22|
|Subject: Re: Starting PostgreSQL 8.0.4 with more memory [FreeBSD|
|Previous:||From: Steve Crawford||Date: 2005-10-31 18:43:40|
|Subject: Re: Installation trouble|