Re: Upgrading to 9.4 to get replication slots (was Re: Streaming replication and WAL archiving)

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: "David F(dot) Skoll" <dfs(at)roaringpenguin(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Upgrading to 9.4 to get replication slots (was Re: Streaming replication and WAL archiving)
Date: 2015-02-11 15:04:43
Message-ID: 2C73CF9C-A3FF-41DA-BDBC-94BE0C18E332@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Feb 11, 2015, at 7:45 AM, David F. Skoll <dfs(at)roaringpenguin(dot)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 downtime to almost 0.

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message David F. Skoll 2015-02-11 15:40:06 Re: Upgrading to 9.4 to get replication slots (was Re: Streaming replication and WAL archiving)
Previous Message David F. Skoll 2015-02-11 14:45:35 Upgrading to 9.4 to get replication slots (was Re: Streaming replication and WAL archiving)