On Tue, Sep 26, 2017 at 6:57 PM, Pavel Stehule <pavel.steh...@gmail.com> wrote: > > > 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 >> >>
Hmm, has a logical replication slot created on the master? 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