Re: replication not replicating

On Tue, Jan 16, 2024 at 4:35 PM Ron Johnson <ronljohnsonjr(at)gmail(dot)com> wrote:

> On Tue, Jan 16, 2024 at 4:10 PM Brad White <b55white(at)gmail(dot)com> wrote:
>
>> Errors from the primary
>>
>> 2024-01-15 00:00:51.157 CST [2660] ERROR: requested WAL segment
>> 0000000100000002000000A2 has already been removed
>> 2024-01-15 00:00:51.157 CST [2660] STATEMENT: START_REPLICATION
>> 2/A2000000 TIMELINE 1
>> 2024-01-15 00:00:56.158 CST [492] ERROR: requested WAL segment
>> 0000000100000002000000A2 has already been removed
>> 2024-01-15 00:00:56.158 CST [492] STATEMENT: START_REPLICATION
>> 2/A2000000 TIMELINE 1
>> 2024-01-15 00:00:56.159 CST [492] LOG: could not receive data from
>> client: An existing connection was forcibly closed by the remote host.
>>
>>
>> 2024-01-15 00:01:01.151 CST [3404] ERROR: requested WAL segment
>> 0000000100000002000000A2 has already been removed
>> 2024-01-15 00:01:01.151 CST [3404] STATEMENT: START_REPLICATION
>> 2/A2000000 TIMELINE 1
>> 2024-01-15 00:01:01.152 CST [3404] LOG: could not receive data from
>> client: An existing connection was forcibly closed by the remote host.
>>
>> [repeat for 55000 lines]
>>
>>
> What database version?
>
v15

> Streaming or Logical replication?
>
IDK

> Using a slot?
>
No.

Relevant sections from the conf

--- Primary ---
#------------------------------------------------------------------------------
# WRITE-AHEAD LOG
#------------------------------------------------------------------------------

# - Settings -

wal_level = replica # minimal, replica, or logical

# - Archiving -

archive_mode = on # enables archiving; off, on, or always
# (change requires restart)
#archive_library = '' # library to use to archive a logfile segment
# (empty string indicates archive_command should
# be used)
archive_command = 'copy %p
"\\\\DISKSTATION\\AccessData\\Prod\\WALfiles\\%f"'
# command to use to archive a
logfile segment
archive_timeout = 0 # force a logfile segment switch after this
# number of seconds; 0 disables

primary_conninfo is set.
Everything else is commented out, using default values.

--- Backup Server ---
#------------------------------------------------------------------------------
# WRITE-AHEAD LOG
#------------------------------------------------------------------------------

# - Settings -

wal_level = replica # minimal, replica, or logical
archive_cleanup_command = 'pg_archivecleanup
\\\\DISKSTATION\\AccessData\\Prod\\WALfiles %r'

# - Archiving -

archive_mode = on

# - Archive Recovery -
#restore_command = ''

>