On Tue, Jan 16, 2024 at 6:26 PM Brad White <b55wh...@gmail.com> wrote:
> 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 = '' > Hmmm. Are you log shipping? If so, why? Streaming Replication is sooo much easier.
