Hi, we have a main studio and a secondary studio linked over a codec and a VPN for data.
At the remote site I access the main DB via the VPN. However the response times are quite poor at the moment when accessing playlists and doing database searches…
So im exploring options so have a local database copy of the main one.
I managed to do backup and restore but it does keep the original mairlist DB which means I have to disconnect the MainDB from mairlist to use the local copy.
I wondered if anyone had managed replication in postgresql or any other suggestions to help please so I can keep the databases in sync.
Im open to any ideas on this one. Even changing database manager if I have to.
Many thanks - Adrian
PS - getting a bigger data connection is not an option unfortunatly!