Re: replication not replicating

On Tue, Jan 16, 2024 at 4:10 PM Brad White <b55white(at)gmail(dot)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]
> --------------------------------------------------------
>
> Errors from the hot backup at roughly the same time
>
> 2024-01-15 01:13:57.893 CST [2988] LOG: started streaming WAL from
> primary at 2/A2000000 on timeline 1
> 2024-01-15 01:13:57.893 CST [2988] FATAL: could not receive data from WAL
> stream: ERROR: requested WAL segment 0000000100000002000000A2 has already
> been removed
> 2024-01-15 01:13:57.893 CST [1792] LOG: waiting for WAL to become
> available at 2/A2002000
> 2024-01-15 01:14:02.884 CST [2552] LOG: started streaming WAL from
> primary at 2/A2000000 on timeline 1
> 2024-01-15 01:14:02.884 CST [2552] FATAL: could not receive data from WAL
> stream: ERROR: requested WAL segment 0000000100000002000000A2 has already
> been removed
> 2024-01-15 01:14:02.884 CST [1792] LOG: waiting for WAL to become
> available at 2/A2002000
>
> [repeat for 49000 lines]
>

What database version?
Streaming or Logical replication?
Using a slot?