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. -- Petr Jelinek http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
