New on LowEndTalk? Please Register and read our Community Rules.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
How can I mirror my PostgreSQL database?
Hi there, I have a database instance (have around 5 databases on it, and has around 15 GB data) on Microsoft Azure, and I also have a VM which is connected to the instance internally (which means, no bandwidth fee).
Here's what I want to do:
I fire up a Docker instance of PostgreSQL, map the database root to a folder in the home directory, let's say /home/frank/psqldb
I want to mirror the whole PostgreSQL instance from Azure (which means the whole server) to the instance I have just created.
So when an INSERT, UPDATE etc. command executes, the mirror instance would sync the original server locally.
How can I do it?
Comments
Streaming replication is your keyword.
https://wiki.postgresql.org/wiki/Streaming_Replication
You may want to use your tools such as barman for backup recovery
https://docs.pgbarman.org/release/3.4.0/
Or patroni for HA https://patroni.readthedocs.io/en/latest/