Re: Logical replication fails when adding multiple replicas

2023-03-23 Thread Will Roper
OK, that makes sense. I think something that is unique to subscribers is sensible, postmaster startup time sounds reasonable! Thanks for looking at it. On Thu, Mar 23, 2023 at 8:17 AM Kyotaro Horiguchi wrote: > At Wed, 22 Mar 2023 09:25:37 +, Will Roper < > will.ro...@democracyclub.org.uk> w

Re: Logical replication fails when adding multiple replicas

2023-03-23 Thread Kyotaro Horiguchi
At Wed, 22 Mar 2023 09:25:37 +, Will Roper wrote in > Thanks for the response Hou, > > I've had a look and when the tablesync workers are spinning up there are > some errors of the form: > > "2023-03-17 18:37:06.900 UTC [4071] LOG: logical replication table > synchronization worker for su

Re: Logical replication fails when adding multiple replicas

2023-03-22 Thread Will Roper
Thanks for the response Hou, I've had a look and when the tablesync workers are spinning up there are some errors of the form: "2023-03-17 18:37:06.900 UTC [4071] LOG: logical replication table synchronization worker for subscription ""polling_stations_0561a02f66363d911"", table ""uk_geo_utils_o

RE: Logical replication fails when adding multiple replicas

2023-03-21 Thread houzj.f...@fujitsu.com
On Monday, March 20, 2023 8:46 PM Will Roper wrote: Hi, > We’re having some issues with Postgresql’s logical replication. Specifically > trying to add several replicas at once. Essentially we can add replicas one at > a time, but when we try and add two or more together some of the table > sub