Re: Warm standby with 8.1

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(at)rice(dot)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
> >
>