On Mon, May 15, 2017 at 4:39 PM, Masahiko Sawada <sawada.m...@gmail.com> wrote:
While testing with logical replication, I've found that the server hangs if we create a subscription to the same server. For example, $ ./pg_ctl -D Test start -o "-p 5432" $ ./psql -p 5432 postgres -c "CREATE PUBLICATION abc for all tables with (publish='delete');" $ ./psql -p 5432 postgres -c "create subscription sub connection 'dbname=postgres port=5432 user=edb password=edb' publication abc with (slot_name='abcslot');" NOTICE: synchronized table states LOG: logical decoding found initial starting point at 0/162DF18 DETAIL: Waiting for transactions (approximately 1) older than 560 to end. And, it hangs. Is this an expected behavior? -- Thanks & Regards, Kuntal Ghosh EnterpriseDB: http://www.enterprisedb.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers