Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YLZOh-00062a-Ub for pgsql-admin@arkaria.postgresql.org; Wed, 11 Feb 2015 15:40:16 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YLZOh-0000uw-An for pgsql-admin@arkaria.postgresql.org; Wed, 11 Feb 2015 15:40:15 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YLZOg-0000uQ-HU for pgsql-admin@postgresql.org; Wed, 11 Feb 2015 15:40:14 +0000 Received: from www.ipv6.roaringpenguin.com ([2607:f748:1200:fb:70:38:112:54] helo=colo3.roaringpenguin.com) by magus.postgresql.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1YLZOc-0001PI-Ix for pgsql-admin@postgresql.org; Wed, 11 Feb 2015 15:40:13 +0000 Received: from vanadium.roaringpenguin.com ([192.168.10.23]) by colo3.roaringpenguin.com (8.14.3/8.14.3/Debian-9.4) with ESMTP id t1BFe7p0020295 for ; Wed, 11 Feb 2015 10:40:07 -0500 Received: from hydrogen.roaringpenguin.com (dfs@hydrogen.roaringpenguin.com [192.168.10.1]) by vanadium.roaringpenguin.com (8.14.4/8.14.4/Debian-4) with ESMTP id t1BFe6pu027614 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES128-SHA bits=128 verify=NOT) for ; Wed, 11 Feb 2015 10:40:06 -0500 Date: Wed, 11 Feb 2015 10:40:06 -0500 From: "David F. Skoll" To: pgsql-admin@postgresql.org Subject: Re: Upgrading to 9.4 to get replication slots (was Re: Streaming replication and WAL archiving) Message-ID: <20150211104006.01e7fee9@hydrogen.roaringpenguin.com> In-Reply-To: <2C73CF9C-A3FF-41DA-BDBC-94BE0C18E332@elevated-dev.com> References: <20150210172139.237ffb0b@ollie.roaringpenguin.com> <20150211092743.460e6bfe@hydrogen.roaringpenguin.com> <54DB693A.7010705@gmail.com> <20150211094535.5f130601@hydrogen.roaringpenguin.com> <2C73CF9C-A3FF-41DA-BDBC-94BE0C18E332@elevated-dev.com> Organization: Roaring Penguin Software Inc. X-Mailer: Claws Mail 3.8.1 (GTK+ 2.24.10; x86_64-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit DKIM-Signature: v=1; a=rsa-sha1; c=relaxed; d=roaringpenguin.com; h=date :from:to:subject:message-id:in-reply-to:references:mime-version :content-type:content-transfer-encoding; s=main; bh=LPY19ZnBeVPf PEjB5yhI5H445vg=; b=CV91nWzLhMBR2fr4JAzKHrMntRukdm/8W7zvYDI9+Zc1 GJz0FG4CKRDugI/eOT9JX5O611BkoNnfhYVairRabFGiPqRaAJ47RTVy+bCO/NDT 1yrVKtz/PU4tTHU5M4pvY4igJJiDwjdXpVqd6p6o2Mm8Mlocjr1QD1ZxsYonDIZw vA2+Uty1sxeyY0tTcbdvxrGAan0twK7YCWIs47YA5ROX3dieU+SUUA0sT72eTjlo pO7kOmJG39OgpjlCH+awR9Wlp59m1kXxuVw5SUr038xexVEwdG6cZ7+92s3ju//8 zsRJ2Wkk+dTiKpyEyeL88d4ufZqqAf6WP94fmI1+iQ== X-Scanned-By: CanIt (www . roaringpenguin . com) X-Scanned-By: MIMEDefang 2.75 on 192.168.10.23 X-Spam-Score: undef - relay 192.168.10.23 marked with skip_spam_scan X-CanIt-Geo: No geolocation information available for 192.168.10.23 X-CanItPRO-Stream: outgoing (inherits from default) X-CanIt-Archive-Cluster: SQVyZJxqklY5buiWXYCN4T/BjiM X-CanIt-Archived-As: base/20150211 / 01NP3E79C X-Pg-Spam-Score: -4.3 (----) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org On Wed, 11 Feb 2015 08:04:43 -0700 Scott Ribe 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