Re: logical replication and statistics

2017-09-25 13:12 GMT+02:00 Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>:

> On Mon, Sep 25, 2017 at 12:58 AM, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)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
>