PostgreSQL 12 High Availability Cookbook - Third Edition

How to do it…

Assuming we have our old server (pg-old) and a new server (pg-new) to act as the subscriber, follow these instructions to monitor the subscription progress of the myapp database:

1. Use this query on pg-new to check the state of the subscription itself:

SELECT *   FROM pglogical.show_subscription_status(         'myapp_upgrade'       );

2. Run this query on both systems to get an idea of the relative database size:

SELECT pg_size_pretty(pg_database_size('myapp'));

3. Execute the following query on both servers to check the current table being synchronized:

SELECT application_name, query, state_change  FROM pg_stat_activity WHERE application_name LIKE 'myapp\_%';

4. Run this query on both systems to compare information for the table currently being ...