Re: replication not replicating - Mailing list pgsql-general
| From | Brad White |
|---|---|
| Subject | Re: replication not replicating |
| Date | |
| Msg-id | CAA_1=92Ot2-fxsEbWwwsAaEpKhdR_GgF6=a7EeTAtv2hFtpePw@mail.gmail.com Whole thread Raw |
| In response to | Re: replication not replicating (Ron Johnson <ronljohnsonjr@gmail.com>) |
| Responses |
Re: replication not replicating
|
| List | pgsql-general |
On Tue, Jan 16, 2024 at 4:35 PM Ron Johnson <ronljohnsonjr@gmail.com> wrote:
On Tue, Jan 16, 2024 at 4:10 PM Brad White <b55white@gmail.com> wrote:Errors from the primary2024-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
# 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
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
# 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_mode = on
# - Archive Recovery -
#restore_command = ''
pgsql-general by date: