Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YLYGh-0003ZT-W2 for pgsql-admin@arkaria.postgresql.org; Wed, 11 Feb 2015 14:27:56 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YLYGh-0000G9-Ed for pgsql-admin@arkaria.postgresql.org; Wed, 11 Feb 2015 14:27:55 +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 1YLYGf-0000DH-HH for pgsql-admin@postgresql.org; Wed, 11 Feb 2015 14:27:53 +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 1YLYGa-0008T2-OD for pgsql-admin@postgresql.org; Wed, 11 Feb 2015 14:27:51 +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 t1BERiXI002819; Wed, 11 Feb 2015 09:27:44 -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 t1BERhuM003369 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES128-SHA bits=128 verify=NOT); Wed, 11 Feb 2015 09:27:43 -0500 Date: Wed, 11 Feb 2015 09:27:43 -0500 From: "David F. Skoll" To: pgsql-admin@postgresql.org Cc: Greg Clough Subject: Re: Streaming replication and WAL archiving Message-ID: <20150211092743.460e6bfe@hydrogen.roaringpenguin.com> In-Reply-To: References: <20150210172139.237ffb0b@ollie.roaringpenguin.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:cc:subject:message-id:in-reply-to:references :mime-version:content-type:content-transfer-encoding; s=main; bh=KRg7bN6CPWv9qnTn2UkGmcRe6H4=; b=P5VgG3/+aAZKIBrJq2L4yrzajHDw lj1VDBmUoSqH6AJ2y5XWfeJDJ48DANPQQ5orcYOYLR7W+h+zlKpCmZ7ElaRBCTK4 QWLl0L7R+c5M4XaITrHl+zdbswH8BV8L5QECdEbfgnw+h4q6qpG2CIgtUSjGdNpl wvrtTg+ZufI35ZfJSDAnxNPp8SyV7khD5oRP/DyYEo2MxYUG+bEkrxTHuKDno12N rRNBRUekmFoXkmuAilv36GGUCs3K6wf0LmWIA2c41V5VKvP+yLom9o13vjw/MMVB NYHu8TyLvbuLZHZ5X2M9ijhgRXiHlSU4EZ9fkuHfWfGl3xospsHT0yZEzw== 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 / 01NP2rI6l 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 09:04:44 +0000 Greg Clough wrote: > Have you investigated the "Replication Slots" feature that's new in > 9.4. It sounds like what you want: Yes, it is exactly what I want... thanks! Now to plan the upgrade from 9.1 to 9.4... it's not exactly trivial. The database is about 400GB which is large enough to be unwieldy and it powers our anti-spam service... that means we can't be down for very long. :( Time to re-familiarize myself with pg_upgrade... 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