From: | hubert depesz lubaczewski <depesz(at)depesz(dot)com> |
---|---|
To: | pgsql-general mailing list <pgsql-general(at)postgresql(dot)org> |
Subject: | pglogical replication dies |
Date: | 2019-08-09 11:49:45 |
Message-ID: | 20190809114945.GA20969@depesz.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I tried to setup upgrade using pglogical - from 9.5 to 11.
I did set it up, and after subscription, initial data sync seems to work
fine, but then replication dies.
In logs on subscriber, every 3 minutes I see:
db=,user= LOG: background worker "pglogical apply 114610049:2875150205" (PID 28020) exited with exit code 1
On provider there are more messages. Every 3 minutes I get:
LOG: replication connection authorized: user=some_user SSL enabled (protocol=TLSv1.3, cipher=TLS_AES_256_GCM_SHA384, compression=off)
LOG: starting logical decoding for slot "pgl_somedb_provider_subscription"
DETAIL: streaming transactions committing after 4AA0/5B43630, reading WAL from 4AA0/55743C0
LOG: logical decoding found consistent point at 4AA0/55743C0
DETAIL: There are no running transactions.
LOG: could not receive data from client: Connection reset by peer
LOG: unexpected EOF on standby connection
And that's all.
If it matters there are ~ 3000 tables in the replication set, and we
don't replicate sequences (figured it will be simpler to just sync them
once on switch to new server).
How to debug/diagnose the problem?
Best regards,
depesz
From | Date | Subject | |
---|---|---|---|
Next Message | Paolo Saudin | 2019-08-09 12:28:07 | Re: Recomended front ends? |
Previous Message | Ramesh Maddi | 2019-08-09 11:25:13 | Re: Understanding PostgreSQL installer debug log |