PostgreSQL 12 High Availability Cookbook - Third Edition

How to do it...

As with all of the previous recipes, pgha2 will remain our replication subscriber. Execute all commands in this recipe on the provider system (pgha1) as the postgres system user. Follow these steps to copy the sample pgbench tables:

1. Extract the table creation statements from the primary node with the following command:

pg_dump -s -t 'pgbench*' postgres > /tmp/tables.sql

2. Create the empty tables on the subscriber node by executing this command on the primary node:

psql -U rep_user -h pgha2 -f /tmp/tables.sql postgres

3. Add all of the pgbench tables to Bucardo with these commands:

bucardo add table pgbench_accounts db=pgha1
bucardo add table pgbench_branches db=pgha1
bucardo add table pgbench_tellers db=pgha1

4. Confirm tables ...