On Wed, Jan 31, 2024 at 11:35 AM Euler Taveira <eu...@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 Attached the output log. Regards, -- Fabrízio de Royes Mello
2024-01-31 11:53:31.882 -03 [706626] LOG: starting PostgreSQL 17devel on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 11.4.0-1ubuntu1~22.04) 11.4.0, 64-bit 2024-01-31 11:53:31.882 -03 [706626] LOG: listening on IPv6 address "::1", port 5434 2024-01-31 11:53:31.882 -03 [706626] LOG: listening on IPv4 address "127.0.0.1", port 5434 2024-01-31 11:53:31.990 -03 [706626] LOG: listening on Unix socket "/tmp/.s.PGSQL.5434" 2024-01-31 11:53:32.082 -03 [706639] LOG: database system was shut down in recovery at 2024-01-31 11:53:30 -03 2024-01-31 11:53:32.084 -03 [706639] LOG: entering standby mode 2024-01-31 11:53:32.100 -03 [706639] LOG: redo starts at 0/4000028 2024-01-31 11:53:32.189 -03 [706639] LOG: consistent recovery state reached at 0/69EFF00 2024-01-31 11:53:32.189 -03 [706639] LOG: invalid record length at 0/69F01D0: expected at least 24, got 0 2024-01-31 11:53:32.189 -03 [706626] LOG: database system is ready to accept read-only connections 2024-01-31 11:53:32.200 -03 [706640] LOG: started streaming WAL from primary at 0/6000000 on timeline 1 2024-01-31 11:53:32.218 -03 [706639] LOG: recovery stopping after WAL location (LSN) "0/6A1F4C0" 2024-01-31 11:53:32.218 -03 [706639] LOG: redo done at 0/6A1F4C0 system usage: CPU: user: 0.07 s, system: 0.01 s, elapsed: 0.11 s 2024-01-31 11:53:32.219 -03 [706639] LOG: last completed transaction was at log time 2024-01-31 11:53:31.745182-03 2024-01-31 11:53:32.220 -03 [706640] FATAL: terminating walreceiver process due to administrator command 2024-01-31 11:53:32.266 -03 [706639] LOG: selected new timeline ID: 2 2024-01-31 11:53:32.390 -03 [706639] LOG: archive recovery complete 2024-01-31 11:53:32.403 -03 [706637] LOG: checkpoint starting: end-of-recovery immediate wait 2024-01-31 11:53:32.809 -03 [706637] LOG: checkpoint complete: wrote 2141 buffers (13.1%); 0 WAL file(s) added, 0 removed, 2 recycled; write=0.067 s, sync=0.198 s, total=0.419 s; sync files=51, longest=0.018 s, average=0.004 s; distance=43133 kB, estimate=43133 kB; lsn=0/6A1F4F8, redo lsn=0/6A1F4F8 2024-01-31 11:53:32.827 -03 [706626] LOG: database system is ready to accept connections 2024-01-31 11:53:33.398 -03 [706626] LOG: received fast shutdown request 2024-01-31 11:53:33.409 -03 [706650] LOG: logical replication apply worker for subscription "pg_createsubscriber_16384_706609" has started 2024-01-31 11:53:33.414 -03 [706626] LOG: aborting any active transactions 2024-01-31 11:53:33.414 -03 [706650] FATAL: terminating logical replication worker due to administrator command 2024-01-31 11:53:33.415 -03 [706626] LOG: background worker "logical replication launcher" (PID 706645) exited with exit code 1 2024-01-31 11:53:33.415 -03 [706626] LOG: background worker "logical replication apply worker" (PID 706650) exited with exit code 1 2024-01-31 11:53:33.415 -03 [706637] LOG: shutting down 2024-01-31 11:53:33.438 -03 [706637] LOG: checkpoint starting: shutdown immediate 2024-01-31 11:53:33.642 -03 [706637] LOG: checkpoint complete: wrote 23 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.052 s, sync=0.047 s, total=0.228 s; sync files=14, longest=0.011 s, average=0.004 s; distance=3 kB, estimate=38820 kB; lsn=0/6A20270, redo lsn=0/6A20270 2024-01-31 11:53:33.648 -03 [706626] LOG: database system is shut down
