On Tue, Jan 16, 2024 at 4:35 PM Ron Johnson <ronljohnso...@gmail.com> wrote:
> On Tue, Jan 16, 2024 at 4:10 PM Brad White <b55wh...@gmail.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 = ''
>
