2017-09-25 13:12 GMT+02:00 Masahiko Sawada <sawada.m...@gmail.com>: > 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. >
I used this subscriptions for and it was warking. Regards Pavel > Regards, > > -- > Masahiko Sawada > NIPPON TELEGRAPH AND TELEPHONE CORPORATION > NTT Open Source Software Center >
