From: | Petr Jelinek <petr(at)2ndquadrant(dot)com> |
---|---|
To: | Erik Rijkers <er(at)xs4all(dot)nl> |
Cc: | Stas Kelvich <s(dot)kelvich(at)postgrespro(dot)ru>, Craig Ringer <craig(at)2ndquadrant(dot)com>, Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>, Simon Riggs <simon(at)2ndquadrant(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, pgsql-hackers-owner(at)postgresql(dot)org |
Subject: | Re: Logical Replication WIP |
Date: | 2016-09-08 14:51:33 |
Message-ID: | 4c868c4c-65c5-19f0-51aa-3e9b4d86ba01@2ndquadrant.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi,
On 07/09/16 14:10, Erik Rijkers wrote:
> On 2016-08-31 22:51, Petr Jelinek wrote:
>>
>> and one more version with bug fixes, improved code docs and couple
>
>
> I am not able to get the replication to work. Would you (or anyone) be
> so kind to point out what I am doing wrong?
>
> Patches applied, compiled, make-checked, installed OK.
>
> I have 2 copies compiled and installed, logical_replication and
> logical_replication2, to be publisher and subscriber, ports 6972 and
> 6973 respectively.
>
>
> Logfile subscriber-side:
> [...]
> 2016-09-07 13:47:44.441 CEST 21997 LOG: MultiXact member wraparound
> protections are now enabled
> 2016-09-07 13:47:44.528 CEST 21986 LOG: database system is ready to
> accept connections
> 2016-09-07 13:47:44.529 CEST 22002 LOG: logical replication launcher
> started
> 2016-09-07 13:52:11.319 CEST 22143 LOG: logical replication apply for
> subscription sub1 started
> 2016-09-07 13:53:47.010 CEST 22143 ERROR: could not open relation with
> OID 0
> 2016-09-07 13:53:47.012 CEST 21986 LOG: worker process: logical
> replication worker 24048 (PID 22143) exited with exit code 1
> 2016-09-07 13:53:47.018 CEST 22184 LOG: logical replication apply for
> subscription sub1 started
> 2016-09-07 13:53:47.028 CEST 22184 ERROR: could not open relation with
> OID 0
> 2016-09-07 13:53:47.030 CEST 21986 LOG: worker process: logical
> replication worker 24048 (PID 22184) exited with exit code 1
> 2016-09-07 13:53:52.041 CEST 22187 LOG: logical replication apply for
> subscription sub1 started
> 2016-09-07 13:53:52.045 CEST 22187 ERROR: could not open relation with
> OID 0
> 2016-09-07 13:53:52.046 CEST 21986 LOG: worker process: logical
> replication worker 24048 (PID 22187) exited with exit code 1
> (repeat every few seconds)
>
>
It means the tables don't exist on subscriber. I added check and proper
error message in my local dev branch, it will be part of the next update.
--
Petr Jelinek http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
From | Date | Subject | |
---|---|---|---|
Next Message | Pavan Deolasee | 2016-09-08 14:54:19 | Re: Vacuum: allow usage of more than 1GB of work mem |
Previous Message | Aleksander Alekseev | 2016-09-08 14:48:25 | Re: Patch: Implement failover on libpq connect level. |