Cross Site Database Replication with local files

English mAirList 7.x
1

I’ve seen a few posts here in the forum, but none with an actual solution.
We are running database and file storage locally in our studio, with all the hosts accessing the server remotely via VPN for VT and scheduling purposes. Some times our ISP is giving us a hard time with no service for a day (!). In these cases it would be great if we had a remote replication of the database.

Myself i have a copy of all the files locally at my office, and a local sqlite dump. One of the issues with this is the path to all the files are notning like in the studio… And the sqlite dump is often far from updated…

I’ve read about postgres master-slave replication. Is this the solution?
How can i set this up for the slave in my office to recognize the local files instead of the files in the studio?

If you have a similar usecase or experience, all replies is highly appraciated.
Thomas

2

My database is on a Nas (same room)
De nas make’s a copy to the H disk in my mairlist pc.
But it can also sync between a remote location.
Year’s ago I had a podcast and the guy that made the RSS feed had a share file folder.
I only think you get a problem with de database file.

3

Hi Henk!
Thank you for your reply, you are right. We can use some NAS solution with rsync or RRTR replication. A more realtime solution would be preferred but… yeah.

The PG Database is an issue. hm

Thomas