2017-09-26 11:51 GMT+02:00 Masahiko Sawada <sawada.m...@gmail.com>: > On Tue, Sep 26, 2017 at 2:50 AM, Pavel Stehule <pavel.steh...@gmail.com> > wrote: > > > > > > 2017-09-25 19:23 GMT+02:00 Petr Jelinek <petr.jeli...@2ndquadrant.com>: > >> > >> On 25/09/17 19:19, Tom Lane wrote: > >> > Pavel Stehule <pavel.steh...@gmail.com> writes: > >> >> I had two instances on one server with different port. I am sure, so > >> >> replication was functional. Only one issue is statistics > >> > > >> >> Master: > >> > > >> >> CREATE TABLE foo(id int primary key, a int); > >> >> CREATE PUBLICATION test_pub FOR TABLE foo; > >> >> INSERT INTO foo VALUES(1, 200); > >> > > >> >> slave > >> > > >> >> CREATE TABLE foo(id int primary key, a int); > >> >> CREATE SUBSCRIPTION test_sub CONNECTION 'port=5432' PUBLICATION > >> >> test_pub; > >> > > >> >> That was all > >> > > >> > In this example, nothing's been done yet by the actual replication > >> > apply process, only by the initial table sync. Maybe that accounts > >> > for your not seeing stats? > >> > > >> > >> The main replication worker should still be running though. The output > >> of pg_stat_replication should only be empty if there is nothing running. > >> > > > > I did some inserts, updates, .. > > > > I can recheck it - it was done on 10 RC > > I guess CREATE SUBSCRIPTION failed for whatever reason (e.g, wal_level > < logical on the master). Didn't you get errors from CREATE > SUBSCRIPTION? >
sorry I had wal_level = logical Pavel > > Regards, > > -- > Masahiko Sawada > NIPPON TELEGRAPH AND TELEPHONE CORPORATION > NTT Open Source Software Center >
