Re: Replication Recommendation

On 09/12/2016 12:46 PM, Lee Hachadoorian wrote:
> There are a wide variety of Postgres replication solutions, and I
> would like advice on which one would be appropriate to my use case.
>
> * Small (~half dozen) distributed workforce using a file sharing
> service, but without access to direct network connection over the
> internet
> * Database is updated infrequently, when new government agency data
> releases replace old data
> * Because database is updated infrequently, workforce can come
> together for LAN-based replication as needed
> * Entire database is on the order of a few GB
>
> Given this, I am considering the super lowtech "replication" solution
> of updating "master" and doing a full database drop and restore on the
> "slaves". But I would like to know which of the other (real)
> replication solutions might work for this use case.

If I follow correctly the layout is?:

Main database <--- Govt. data
|
|
\ /

File share
|
|
\ /

DB DB DB DB DB DB

User 1 User 2 User 3 User 4 User 5 User 6

For your simple scenario you might want to look at:

https://www.postgresql.org/docs/9.5/static/app-pgbasebackup.html

>
> Regards,
> --Lee
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com