Re: replication not replicating

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: replication not replicating
Дата
Msg-id CANzqJaD2ckfi8X5ath1ry467cH3+pfUcLSDcb_fioJmO-mZy6g@mail.gmail.com
обсуждение исходный текст
Ответ на replication not replicating  (Brad White <b55white@gmail.com>)
Ответы Re: replication not replicating
Список pgsql-general
On Tue, Jan 16, 2024 at 4:10 PM Brad White <b55white@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]
--------------------------------------------------------

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?
 

В списке pgsql-general по дате отправления:

Предыдущее
От: Rob Sargent
Дата:
Сообщение: Re: Mimic ALIAS in Postgresql?
Следующее
От: Ron Johnson
Дата:
Сообщение: Re: Mimic ALIAS in Postgresql?