N1.log
application/octet-stream
Filename: N1.log
Type: application/octet-stream
Part: 0
Message:
RE: speed up a logical replica setup
2024-02-09 11:51:08.395 UTC [3855] LOG: starting PostgreSQL 17devel on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.3.1 20190311 (Red Hat 8.3.1-3), 64-bit
2024-02-09 11:51:08.396 UTC [3855] LOG: listening on IPv6 address "::1", port 5431
2024-02-09 11:51:08.396 UTC [3855] LOG: listening on IPv4 address "127.0.0.1", port 5431
2024-02-09 11:51:08.400 UTC [3855] LOG: listening on Unix socket "/tmp/.s.PGSQL.5431"
2024-02-09 11:51:08.405 UTC [3858] LOG: database system was shut down at 2024-02-09 11:51:08 UTC
2024-02-09 11:51:08.414 UTC [3855] LOG: database system is ready to accept connections
2024-02-09 11:51:08.590 UTC [3856] LOG: checkpoint starting: immediate force wait
2024-02-09 11:51:08.684 UTC [3856] LOG: checkpoint complete: wrote 983 buffers (6.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.051 s, sync=0.036 s, total=0.094 s; sync files=332, longest=0.003 s, average=0.001 s; distance=4541 kB, estimate=4541 kB; lsn=0/1BE1480, redo lsn=0/1BE1428
2024-02-09 11:51:08.740 UTC [3856] LOG: checkpoint starting: force wait
2024-02-09 11:51:12.304 UTC [3856] LOG: checkpoint complete: wrote 36 buffers (0.2%); 0 WAL file(s) added, 0 removed, 1 recycled; write=3.512 s, sync=0.007 s, total=3.564 s; sync files=33, longest=0.002 s, average=0.001 s; distance=4219 kB, estimate=4509 kB; lsn=0/2000080, redo lsn=0/2000028
2024-02-09 11:51:33.042 UTC [3889] LOG: logical decoding found consistent point at 0/3000B28
2024-02-09 11:51:33.042 UTC [3889] DETAIL: There are no running transactions.
2024-02-09 11:51:33.042 UTC [3889] STATEMENT: SELECT lsn FROM pg_create_logical_replication_slot('pg_createsubscriber_5_3884', 'pgoutput', false, false, false)
2024-02-09 11:51:42.821 UTC [3892] WARNING: subscription was created, but is not connected
2024-02-09 11:51:42.821 UTC [3892] HINT: To initiate replication, you must manually create the replication slot, enable the subscription, and refresh the subscription.
2024-02-09 11:51:53.069 UTC [3893] LOG: logical decoding found consistent point at 0/30017C8
2024-02-09 11:51:53.069 UTC [3893] DETAIL: There are no running transactions.
2024-02-09 11:51:53.069 UTC [3893] STATEMENT: SELECT lsn FROM pg_create_logical_replication_slot('pg_createsubscriber_16389_3884', 'pgoutput', false, false, false)
2024-02-09 11:52:13.207 UTC [3895] LOG: logical decoding found consistent point at 0/3003390
2024-02-09 11:52:13.207 UTC [3895] DETAIL: There are no running transactions.
2024-02-09 11:52:13.207 UTC [3895] STATEMENT: SELECT lsn FROM pg_create_logical_replication_slot('pg_createsubscriber_3884_startpoint', 'pgoutput', true, false, false)
2024-02-09 11:52:29.417 UTC [3924] LOG: starting logical decoding for slot "pg_createsubscriber_5_3884"
2024-02-09 11:52:29.417 UTC [3924] DETAIL: Streaming transactions committing after 0/3000B60, reading WAL from 0/3000B28.
2024-02-09 11:52:29.417 UTC [3924] STATEMENT: START_REPLICATION SLOT "pg_createsubscriber_5_3884" LOGICAL 0/30033C8 (proto_version '4', origin 'any', publication_names '"pg_createsubscriber_5"')
2024-02-09 11:52:29.417 UTC [3924] LOG: logical decoding found consistent point at 0/3000B28
2024-02-09 11:52:29.417 UTC [3924] DETAIL: There are no running transactions.
2024-02-09 11:52:29.417 UTC [3924] STATEMENT: START_REPLICATION SLOT "pg_createsubscriber_5_3884" LOGICAL 0/30033C8 (proto_version '4', origin 'any', publication_names '"pg_createsubscriber_5"')
2024-02-09 11:52:29.455 UTC [3927] ERROR: replication slot "pg_createsubscriber_5_3884" does not exist
2024-02-09 11:52:29.455 UTC [3927] STATEMENT: SELECT pg_drop_replication_slot('pg_createsubscriber_5_3884')