Skip site navigation (1) Skip section navigation (2)

Warm standby with 8.1

From: james bardin <jbardin(at)bu(dot)edu>
To: pgsql-admin(at)postgresql(dot)org
Subject: Warm standby with 8.1
Date: 2009-08-18 15:27:40
Message-ID: a3b675320908180827p597c63a5m2069ff012df265be@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
Hello,

I'm working on a warm standby system, and we would like to stick with
the RHEL5 distributed version of postgres, which is still 8.1.

I can setup the system to a point where it's adequate for disaster
recovery, but I'm not comfortable keeping the systems in sync for
failover, maintenance, or testing. I'm familiar with the newer
versions, and most documentation for this doesn't mention 8.1 any
more.

Could someone confirm if this is what I need to do on 8.1?
- Create backup, and send to standby server.
- Ship WALs with archive_command
- When we need to switch over; shutdown, sync pg_xlog, and do a
recovery on the new server.

If I have to sync pg_xlog and recover anyway to get the latest
transactions, should I forgo shipping the WAL archives? Switching
between servers should be rare, but I want something that admins
without postgres experience can handle.

Should I resort to slony?
Use the latest version from the postgres yum repo, and vet it locally?

Thanks
-jim

Responses

pgsql-admin by date

Next:From: Kenneth MarshallDate: 2009-08-18 15:33:42
Subject: Re: Warm standby with 8.1
Previous:From: Kevin GrittnerDate: 2009-08-18 14:00:25
Subject: Re: I know part of the function name, how I can search for it from the CLI

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group