Logical replication fails when adding multiple replicas

2023-03-20 Thread Will Roper
Hello list, 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 subscriptions (as described in pg_subscription_rel) fail to

Re: Logical replication fails when adding multiple replicas

2023-03-22 Thread Will Roper
ynchronization worker for subscription ""polling_stations_0561a02f66363d911"", table ""addressbase_address"" has started" 1679078414331,"2023-03-17 18:40:14.168 UTC [4155] ERROR: could not start WAL streaming: ERROR: replication slot ""pg_3

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 +0000, Will Roper < > will.ro...@democracycl