Step 1: CREATE Two Postgres Peers
There is a guide available for creating a PostgreSQL peer here: CREATE Postgres PEERStep 2: Create and populate tables on the source Postgres PEER
Below script helps creates and populatepgbench_history
with dummy data on your PostgreSQL peer.
Step 3: Create pgbench_history table on the destination PEER
Step 4: Kick off MIRROR with 8 threads and batch size of 10 seconds
Step 5: Monitor the MIRROR
You can connect tolocalhost:8085
to gain full visibility into the different jobs and steps that PeerDB performs under the hood to manage the MIRROR.