On Mon, Sep 25, 2017 at 12:58 AM, Pavel Stehule <pavel.stehule@gmail.com> wrote: > Hi > > I did trivial example of logical replication (one table, one publication, > one subscription) > > I am little bit surprised so after some work - the replication is working, > the statistics are empty > > #master > postgres=# select * from pg_stat_replication ; > (0 rows) > > #slave > postgres=# select * from pg_stat_subscription ; > -[ RECORD 1 ]---------+--------- > subid | 16472 > subname | test_sub > pid | > relid | > received_lsn | > last_msg_send_time | > last_msg_receipt_time | > latest_end_lsn | > latest_end_time | > > Should be some enabled? >
If the subscription is disabled, the statistics of subscription is empty and no wal sender processes launch. The test_sub can start the replication by ALTER SUBSCRIPTION test_sub ENABLE.
I used this subscriptions for and it was warking.
Regards
Pavel
Regards,
-- Masahiko Sawada NIPPON TELEGRAPH AND TELEPHONE CORPORATION NTT Open Source Software Center