Re: replication not replicating

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

> 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:
>>
>>>
>>>> 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.
>

I'm attempting async streaming.