[OSGeo Africa] Postgres replication

[Chuck One]

Hi All,

I have two servers with postgres installed which I would like to keep
sync'd. I had a look at streaming replication (cluster replication) within
postgres but it doesn't fit my requirements. The database will be updated
once a month with about 20GB-40GB of spatial data. The update process
includes a few additional steps to "clean" the data which I do not want to
replicate on the other server.

 My requirements:
1. Sync a single database, better yet, only a few tables within a database;
2. Servers have different hardware specs, with different parameter settings
and user logins;

Postgres 9.4 and up apparently have logical replication options. There is
also pglogical from 2nd quadrant. However, I am unsure how to set up
logical replication. Does anyone have experience with logical replication
and willing to shed some light on the matter?

I am using postgres 9.5.3, postgis 2.2.1, ubuntu server 16.04.

Thanks
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/africa/attachments/20170206/c67aede3/attachment.html>