On Tue, Jan 16, 2024 at 6:24 PM Ron Johnson <ronljohnso...@gmail.com> wrote:
> 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: >> >>> >>>> 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.
