Re: Warm standby with 8.1 - Mailing list pgsql-admin

From Kenneth Marshall
Subject Re: Warm standby with 8.1
Date
Msg-id 20090818180236.GR3776@it.is.rice.edu
Whole thread Raw
In response to Re: Warm standby with 8.1  (james bardin <jbardin@bu.edu>)
List pgsql-admin
On Tue, Aug 18, 2009 at 12:09:25PM -0400, james bardin wrote:
> Thanks Ken. The more I think about it, the more I feel we should move
> away from upstream, and pull the latest version for this.
>
>
> So on with newer versions -
> When using the built-in systems for warm standby, how do I ensure that
> the latest transactions have been archived? Does a clean shutdown
> flush and archive the WAL within the archive_timeout period?
>
> Thanks
> -jim
>

Hi Jim,

I think that you will be really happy at the improvements in the
8.4 release. Regarding the warm-standby, take a look at the contrib
module pg_standby in the 8.4 release. It includes a good example
implementation for this process.

Regards,
Ken

>
>
>
> On Tue, Aug 18, 2009 at 11:33 AM, Kenneth Marshall<ktm@rice.edu> wrote:
> > James,
> >
> > You really, really, really should upgrade to a more recent
> > release. The list of improvements and bugfixes is long and
> > well worth having. 8.1 was released 4 years ago. If you
> > cannot, please, please make certain that you are running
> > the latest point release -- regardless of what is shipping
> > with RHEL5.
> >
> > Good luck,
> > Ken
> >
>

pgsql-admin by date:

Previous
From: Anj Adu
Date:
Subject: vacuum on empty table takes very long
Next
From: Kevin Kempter
Date:
Subject: vacuum question