Re: replication not replicating

[Brad White <b55white@xxxxxxxxx>]

On Tue, Jan 16, 2024 at 6:24 PM Ron Johnson <ronljohnsonjr@xxxxxxxxx> wrote:

On Tue, Jan 16, 2024 at 6:26 PM Brad White <b55white@xxxxxxxxx> wrote:

On Tue, Jan 16, 2024 at 4:35 PM Ron Johnson <ronljohnsonjr@xxxxxxxxx> 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.