Postgres Pro
Downloads
Home   >   mailing lists

Re: Upgrading to 9.4 to get replication slots (was Re: Streaming replication and WAL archiving) - Mailing list pgsql-admin

From Scott Ribe
Subject Re: Upgrading to 9.4 to get replication slots (was Re: Streaming replication and WAL archiving)
Date
Msg-id 2C73CF9C-A3FF-41DA-BDBC-94BE0C18E332@elevated-dev.com
Whole thread Raw
In response to Upgrading to 9.4 to get replication slots (was Re: Streaming replication and WAL archiving)  ("David F. Skoll" <dfs@roaringpenguin.com>)
Responses Re: Upgrading to 9.4 to get replication slots (was Re: Streaming replication and WAL archiving)
List pgsql-admin
Tree view 
On Feb 11, 2015, at 7:45 AM, David F. Skoll <dfs@roaringpenguin.com> wrote:
>
> Dump/restore is not an option for me.  It would mean many hours of
> downtime which is unacceptable.  I can barely get away with two hours
> of downtime and that would have to be in the wee hours of Sunday
> morning.  People tend to get very cranky when their email stops flowing!

I don't remember the beginning of the thread. Did you consider Slony? It's more configuration, but it would reduce
downtimeto almost 0. 

--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice

pgsql-admin by date:

Previous
From: "David F. Skoll"
Date:
Subject: Upgrading to 9.4 to get replication slots (was Re: Streaming replication and WAL archiving)
Next
From: "David F. Skoll"
Date:
Subject: Re: Upgrading to 9.4 to get replication slots (was Re: Streaming replication and WAL archiving)