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

Le 11 févr. 2015 16:42, "David F. Skoll" <dfs(at)roaringpenguin(dot)com> a écrit :
>
> On Wed, 11 Feb 2015 08:04:43 -0700
> Scott Ribe <scott_ribe(at)elevated-dev(dot)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.

This is a good reason to avoid slony but...

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

This is definitely wrong. Slony can do the initial sync by itself (ie
without dump/restore).