Re: replication not replicating

On Tue, Jan 16, 2024 at 6:26 PM Brad White <b55white(at)gmail(dot)com> wrote:

> 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 = ''
>

Hmmm. Are you log shipping?

If so, why? Streaming Replication is sooo much easier.