On Mon, Sep 25, 2017 at 12:58 AM, Pavel Stehule <pavel.steh...@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. Regards, -- Masahiko Sawada NIPPON TELEGRAPH AND TELEPHONE CORPORATION NTT Open Source Software Center -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers