Date: Thu, 19 May 2016 20:30:37 -0500 (PET)
Subject: Re: read-only remote replica
Message-ID: <o1hvb14f95b81ek7aacbuc07.1463707480594@email.android.com>
From: Alvaro Aguayo Garcia-Rada <aaguayo@opensysperu.com>
To: pgsql-admin@postgresql.org, Jon Hancock <jhancock@shellshadow.com>
MIME-Version: 1.0
In-Reply-To: 
 <CAOmNu1heCNNMyQd6hFSoMUiBwQpvEg3Yx4n5wqHnEaxvH9JqNA@mail.gmail.com>
References: 
 <CAOmNu1heCNNMyQd6hFSoMUiBwQpvEg3Yx4n5wqHnEaxvH9JqNA@mail.gmail.com>
Content-Type: multipart/alternative;
	boundary="----=_Part_216322_659340252.1463707837693"
Thread-Topic: read-only remote replica
Thread-Index: wZfjUKCEmau/J0l/H7sZtLdIwdM5ng==
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

------=_Part_216322_659340252.1463707837693
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable

Hi, Jon.

What postgres version are you using on your master database server? If you =
use(or can upgrade to) 9.4/9.5, you can consider using pglogical, which wor=
ks by sending WAL from the master to the read-only slave. It's really effic=
ient, as, unlikely the trigger based replicators, it does not double writes=
 the replicated information. Here's he website: http://2ndquadrant.com/en/r=
esources/pglogical/

Regards,

Alvaro Aguayo
Jefe de Operaciones
Open Comb Systems E.I.R.L.

Oficina: (+51-1)=C2=A03377813=C2=A0| RPM: #034252 / (+51)=C2=A0995540103=C2=
=A0 | RPC: (+51)=C2=A0954183248
Website:=C2=A0www.ocs.pe

Sent from my Sony Xperia=E2=84=A2 smartphone

---- Jon Hancock wrote ----

Hi list,
I need a read only replica of my postgres server (assume
current/recent stable release).
The master is in a reliable data center in California.  The read-only
replica would be in an office in New Zealand.  Bandwidth can be
challenging from our office.  It works but bandwidth is highly
variable.

The reason for the read-only replica is we have an old reports system
in our office that connects directly to the db via ODBC.  Simply too
much work to replace this system for now.  Its not an option to do
nightly dumps/download/imports as we need closer to real time replica.
A few minutes delay is ok.

Any thoughts would be appreciated on how to have a stable/reliable method.

thanks, Jon


--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

------=_Part_216322_659340252.1463707837693
Content-Type: text/html; charset="utf-8"
Content-Transfer-Encoding: quoted-printable

<html><body><div><p dir=3D"ltr">Hi, Jon.</p>
<p dir=3D"ltr">What postgres version are you using on your master database =
server? If you use(or can upgrade to) 9.4/9.5, you can consider using pglog=
ical, which works by sending WAL from the master to the read-only slave. It=
's really efficient, as, unlikely the trigger based replicators, it does no=
t double writes the replicated information. Here's he website: <a href=3D"h=
ttp://2ndquadrant.com/en/resources/pglogical">http://2ndquadrant.com/en/res=
ources/pglogical</a>/</p>
<p dir=3D"ltr">Regards,</p>
<p dir=3D"ltr">Alvaro Aguayo<br>
Jefe de Operaciones<br>
Open Comb Systems E.I.R.L.</p>
<p dir=3D"ltr">Oficina: (+51-1)&#160;3377813&#160;| RPM: #034252 / (+51)=
60;995540103&#160; | RPC: (+51)&#160;954183248<br>
Website:&#160;<a href=3D"http://www.ocs.pe">www.ocs.pe</a></p>
<p dir=3D"ltr">Sent from my Sony Xperia&#8482; smartphone</p>
<br><br>---- Jon Hancock wrote ----<br><br></div><br><div>Hi list,
<br>I need a read only replica of my postgres server (assume
<br>current/recent stable release).
<br>The master is in a reliable data center in California. &nbsp;The read-o=
nly
<br>replica would be in an office in New Zealand. &nbsp;Bandwidth can be
<br>challenging from our office. &nbsp;It works but bandwidth is highly
<br>variable.
<br>
<br>The reason for the read-only replica is we have an old reports system
<br>in our office that connects directly to the db via ODBC. &nbsp;Simply t=
oo
<br>much work to replace this system for now. &nbsp;Its not an option to do
<br>nightly dumps/download/imports as we need closer to real time replica.
<br>A few minutes delay is ok.
<br>
<br>Any thoughts would be appreciated on how to have a stable/reliable meth=
od.
<br>
<br>thanks, Jon
<br>
<br>
<br>--=20
<br>Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
<br>To make changes to your subscription:
<br><a href=3D"http://www.postgresql.org/mailpref/pgsql-admin">http://www.p=
ostgresql.org/mailpref/pgsql-admin</a>
<br></div></body></html>
------=_Part_216322_659340252.1463707837693--