read-only remote replica

From: Jon Hancock <jhancock(at)shellshadow(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: read-only remote replica
Date: 2016-05-19 23:11:24
Message-ID: CAOmNu1heCNNMyQd6hFSoMUiBwQpvEg3Yx4n5wqHnEaxvH9JqNA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Alvaro Aguayo Garcia-Rada 2016-05-20 01:30:37 Re: read-only remote replica
Previous Message Dave Johansen 2016-05-19 19:42:26 NO INHERIT and prepared statements?