From: | Kenneth Marshall <ktm(at)rice(dot)edu> |
---|---|
To: | james bardin <jbardin(at)bu(dot)edu> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Warm standby with 8.1 |
Date: | 2009-08-18 18:02:36 |
Message-ID: | 20090818180236.GR3776@it.is.rice.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(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
> >
>
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Kempter | 2009-08-18 19:19:19 | vacuum question |
Previous Message | Anj Adu | 2009-08-18 17:44:00 | vacuum on empty table takes very long |