pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: David F. Skoll <dfs@roaringpenguin.com>
To: 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 10:40:06 -0500
Message-ID: <20150211104006.01e7fee9@hydrogen.roaringpenguin.com> (raw)
In-Reply-To: <2C73CF9C-A3FF-41DA-BDBC-94BE0C18E332@elevated-dev.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>
	<2C73CF9C-A3FF-41DA-BDBC-94BE0C18E332@elevated-dev.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>

On Wed, 11 Feb 2015 08:04:43 -0700
Scott Ribe <scott_ribe@elevated-dev.com> wrote:

> 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.

We have looked at Slony in the past, but AFAIK it cannot replicate
tables that lack a primary key and we have a few of those.  Also
AFAIK, slony requires an initial sync of the databases with
dump/restore.  Finally our database is quite busy and very
write-heavy, so I worry about the performance impact of all the Slony
triggers.

Regards,

David.


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin



view thread (4+ messages)  latest in thread

Message-ID: <20150211104006.01e7fee9@hydrogen.roaringpenguin.com>
Permalink:  ../20150211104006.01e7fee9@hydrogen.roaringpenguin.com/
Also on:    postgresql.org/message-id/20150211104006.01e7fee9@hydrogen.roaringpenguin.com

 · 

reply
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: dfs@roaringpenguin.com
  Subject: Re: Upgrading to 9.4 to get replication slots (was Re: Streaming replication and WAL archiving)
  In-Reply-To: <20150211104006.01e7fee9@hydrogen.roaringpenguin.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