Re: [pgsql-patches] [GENERAL] Corrupt database? 8.1/FreeBSD6.0 - Mailing list pgsql-patches

From Alvaro Herrera
Subject Re: [pgsql-patches] [GENERAL] Corrupt database? 8.1/FreeBSD6.0
Date
Msg-id 20070205160542.GA7196@alvh.no-ip.org
Whole thread Raw
In response to Re: [pgsql-patches] [GENERAL] Corrupt database? 8.1/FreeBSD6.0  (Bruce Momjian <bruce@momjian.us>)
List pgsql-patches
Bruce Momjian wrote:
>
> What is the status of this patch?

This was applied:

2007-01-14 17:18  alvherre

    * src/backend/postmaster/autovacuum.c:

Fix autovacuum to avoid leaving non-permanent Xids in non-connectable
databases.

Apply to the 8.1 branch only, as the new 8.2 (and HEAD) coding does not have
this problem.


> ---------------------------------------------------------------------------
>
> Alvaro Herrera wrote:
> > Tom Lane wrote:
> > > Alvaro Herrera <alvherre@commandprompt.com> writes:
> >
> > > > Maybe we could forcibly activate the freeze mode on a template database?
> > >
> > > Might not be a bad idea.  And even more to the point, forcibly disable
> > > analyze.
> >
> > Patch implementing this (albeit untested!) attached.  I'll try to
> > reproduce the problem without the patch, and then test with the patch
> > applied.


--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: TM formating patch
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Configuring BLCKSZ and XLOGSEGSZ (in 8.3)