Step 2: Create and populate tables on the source Postgres PEER
Below script helps creates and populate pgbench_history with dummy data on your PostgreSQL peer.
Copy
Ask AI
curl -O https://peerdb-sample-data.s3.us-east-2.amazonaws.com/import_data_for_tutorial.shchmod +x import_data_for_tutorial.sh# "postgres://user:password@hostname:5432/dbname"# is the connection string of your source PostgreSQL peer../import_data_for_tutorial.sh "postgres://user:password@hostname:5432/dbname"
To make it easy in your development and test environments, PeerDB also introduces the DROP MIRROR command. DROP MIRROR drops all the underlying objects that CREATE MIRROR generates. More details are available in this PR.