Re: warm standby replication safe failover

Thanks Tom!

The PostgreSQL 8.4 is coming from the default latest CentOS 6.3 updates
repository which makes it an easy install and upgrade later (yum install
postgresql-server). I'll try installing/upgrading my test setup using
http://yum.postgresql.org repository. I'm also going to need to find out
what migrating to a newer version will affect with the current production
data.
Andrew

On Sat, Feb 2, 2013 at 12:19 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Andrew Puschak <apuschak(at)gmail(dot)com> writes:
> > I'm new here and have a question. I'm working on a replacement PostgreSQL
> > 8.4 setup for a small company. They now have a Primary postgres server
> and
> > 2 secondaries which are replicated using Slony-I, however the consulting
> > company that set it up is afraid to failover and keeping Slony running is
> > taking lots of resources.
>
> It sounds like you're trying to keep them on 8.4. Why not move them to
> some newer release branch where you can make use of streaming
> replication? Aside from the benefits of that, 8.4 will be out of
> support next year, so setting up new servers with that release series
> seems pretty short-sighted.
>
> I realize that dealing with a version upgrade might not be their highest
> priority right now, but they're going to have to deal with it before too
> long, and doing so now would put them in position to have a far better
> replication solution than what you're describing.
>
> regards, tom lane
>

--
Andrew Puschak
(267) 614 - 2373
apuschak(at)gmail(dot)com
http://andrewpuschak.com