From: Scott Ribe <scott_ribe@elevated-dev.com>
To: David F. Skoll <dfs@roaringpenguin.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Upgrading to 9.4 to get replication slots (was Re: Streaming replication and WAL archiving)
Date: Wed, 11 Feb 2015 08:04:43 -0700
Message-ID: <2C73CF9C-A3FF-41DA-BDBC-94BE0C18E332@elevated-dev.com> (raw)
In-Reply-To: <20150211094535.5f130601@hydrogen.roaringpenguin.com>
References: <20150210172139.237ffb0b@ollie.roaringpenguin.com>
<CABZWJif7cJ1xFpQaLUifgAGhgxs3=iyKG2p3wyr4BCUs6Krwpg@mail.gmail.com>
<20150211092743.460e6bfe@hydrogen.roaringpenguin.com>
<54DB693A.7010705@gmail.com>
<20150211094535.5f130601@hydrogen.roaringpenguin.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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 downtime to almost 0.
--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scott_ribe@elevated-dev.com, dfs@roaringpenguin.com
Subject: Re: Upgrading to 9.4 to get replication slots (was Re: Streaming replication and WAL archiving)
In-Reply-To: <2C73CF9C-A3FF-41DA-BDBC-94BE0C18E332@elevated-dev.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox