On Wed, 11 Feb 2015 08:04:43 -0700 Scott Ribe <scott_ribe@xxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
