Re: speed up a logical replica setup

On Wed, Jan 31, 2024 at 11:35 AM Euler Taveira <euler@eulerto.com> wrote:

>

> On Wed, Jan 31, 2024, at 11:25 AM, Fabrízio de Royes Mello wrote:

>

> Jumping into this a bit late here... I'm trying a simple pg_createsubscriber but getting an error:

>

>

> Try v11. It seems v12-0002 is not correct.

Using v11 I'm getting this error:

~/pgsql took 22s

✦ ➜ pg_createsubscriber -d fabrizio -r -D /tmp/replica5434 -S 'host=/tmp port=5434' -P 'host=/tmp port=5432'

NOTICE:  changed the failover state of replication slot "pg_createsubscriber_16384_706609" on publisher to false

pg_createsubscriber: error: could not drop replication slot "pg_createsubscriber_706609_startpoint" on database "fabrizio": ERROR:  replication slot "pg_createsubscriber_706609_startpoint" does not exist

Write-ahead log reset