Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Vq3dG-0001fg-Jr for pgsql-general@arkaria.postgresql.org; Mon, 09 Dec 2013 16:24:30 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Vq3dG-00058S-41 for pgsql-general@arkaria.postgresql.org; Mon, 09 Dec 2013 16:24:30 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Vq3dF-00058J-1f for pgsql-general@postgresql.org; Mon, 09 Dec 2013 16:24:29 +0000 Received: from white.silentmedia.com ([70.90.189.49] helo=mail.silentmedia.com) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Vq3dB-0002MJ-J0 for pgsql-general@postgresql.org; Mon, 09 Dec 2013 16:24:28 +0000 Received: by mail.silentmedia.com (Postfix, from userid 99) id 359571091C3; Mon, 9 Dec 2013 05:53:10 -0800 (PST) X-Spam-Checker-Version: SpamAssassin 3.3.1 (2010-03-16) on mail X-Spam-Level: X-Spam-Status: No, score=0.7 required=5.0 tests=ALL_TRUSTED,BAYES_00, FS_REPLICA,HTML_MESSAGE autolearn=no version=3.3.1 Received: from [10.2.3.2] (candyman [10.2.3.2]) by mail.silentmedia.com (Postfix) with ESMTPA id 700951091C3; Mon, 9 Dec 2013 05:53:09 -0800 (PST) Subject: Re: PG replication across DataCenters Mime-Version: 1.0 (Apple Message framework v1085) Content-Type: multipart/alternative; boundary=Apple-Mail-359-277170111 From: Ben Chobot In-Reply-To: <52A5EB31.7070505@nybeta.com> Date: Mon, 9 Dec 2013 08:24:23 -0800 Cc: pgsql-general General Message-Id: <9F208972-32D3-4295-A30D-BCDAEF139E9F@silentmedia.com> References: <52A5EB31.7070505@nybeta.com> To: Thomas Harold X-Mailer: Apple Mail (2.1085) 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 --Apple-Mail-359-277170111 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii On Dec 9, 2013, at 8:09 AM, Thomas Harold wrote: > 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. >>=20 >> 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. >>=20 >=20 > Something that section 25 in the pgsql documentation is not clear = about for hot-standby with WAL log shipping using the built-in = streaming: >=20 > 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. No, with the built-in binary replication, it's all or nothing, and the = slaves have to have the exact same schema as the master (no adding or = removing indices, for example.) Out of curiosity what did you find unclear about = http://www.postgresql.org/docs/9.3/static/different-replication-solutions.= html?= --Apple-Mail-359-277170111 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii
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.

No, with the built-in = binary replication, it's all or nothing, and the slaves have to have the = exact same schema as the master (no adding or removing indices, for = example.)

= --Apple-Mail-359-277170111--