Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Vq3On-00012F-Ht for pgsql-general@arkaria.postgresql.org; Mon, 09 Dec 2013 16:09:33 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Vq3Om-0005DT-TC for pgsql-general@arkaria.postgresql.org; Mon, 09 Dec 2013 16:09:32 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Vq3Ol-0005DK-O9 for pgsql-general@postgresql.org; Mon, 09 Dec 2013 16:09:31 +0000 Received: from mail.nybeta.com ([207.97.179.66]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Vq3Oe-0004YS-RW for pgsql-general@postgresql.org; Mon, 09 Dec 2013 16:09:31 +0000 Received: from amavisd.intra.nybeta.com (unknown [127.0.0.1]) by mail.nybeta.com (Postfix) with ESMTP id 0D1694032C; Mon, 9 Dec 2013 16:09:23 +0000 (UTC) X-Virus-Scanned: amavisd-new at nybeta.com Received: from mail.nybeta.com ([127.0.0.1]) by amavisd.intra.nybeta.com (mail.nybeta.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id W-p5nw76F9cE; Mon, 9 Dec 2013 11:09:22 -0500 (EST) Received: from [172.30.6.5] (unknown [172.30.6.5]) (using TLSv1 with cipher DHE-RSA-CAMELLIA256-SHA (256/256 bits)) (No client certificate requested) (Authenticated sender: thomas-lists@nybeta.com) by mail.nybeta.com (Postfix) with ESMTPSA id CEEE940028; Mon, 9 Dec 2013 11:09:21 -0500 (EST) Message-ID: <52A5EB31.7070505@nybeta.com> Date: Mon, 09 Dec 2013 11:09:21 -0500 From: Thomas Harold User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:24.0) Gecko/20100101 Thunderbird/24.1.1 MIME-Version: 1.0 To: Albe Laurenz , "pgsql-general@postgresql.org" Subject: Re: PG replication across DataCenters References: In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-general Precedence: bulk Sender: pgsql-general-owner@postgresql.org On 11/22/2013 5:57 AM, Albe Laurenz wrote: > Kaushal Shriyan wrote: >> I have read on the web that Postgresql DB supports replication >> across data centers. Any real life usecase examples if it has been >> implemented by anyone. > > Well, we replicate a 1 TB database between two locations. It is a > fairly active OLTP application, but certainly not pushing the limits > of what PostgreSQL can do in transactions per second. > Something that section 25 in the pgsql documentation is not clear about for hot-standby with WAL log shipping using the built-in streaming: Can you choose which databases / tables on the master server get streamed to the hot-standby read-only server at the remote site? If not, I suspect we'll have to go with either Slony or Bucardo. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general