2017-09-26 11:56 GMT+02:00 Pavel Stehule <pavel.steh...@gmail.com>: > > > 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 >
but if I remember - maybe I had this level only on master > > Pavel > >> >> Regards, >> >> -- >> Masahiko Sawada >> NIPPON TELEGRAPH AND TELEPHONE CORPORATION >> NTT Open Source Software Center >> > >