May 2018
Intermediate to advanced
576 pages
30h 25m
English
Let's look at a few different examples of how to use logical replication:
SELECT pglogical.replication_set_add_all_tables( set_name := 'default', schema_names := ARRAY['public'], true);
And then, by issuing the following command on nodeB:
SELECT pglogical.create_subscription( subscription_name := 'my_subscription_name', provide_dsn := 'host=nodeA dbname=postgres' );
SELECT pglogical.create_replication_set( set_name := 'SmallSet');SELECT pglogical.replication_set_add_table( set_name := 'SmallSet', relation := 'TableX');
And then immediately copy all table ...