Re: PostgreSQL logical replication depends on WAL segments?

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: PostgreSQL logical replication depends on WAL segments?
Дата
Msg-id 20190122185203.dxv5abjm5dxuh5zz@alap3.anarazel.de
обсуждение исходный текст
Ответ на PostgreSQL logical replication depends on WAL segments?  (Josef Machytka <josef.machytka@gmail.com>)
Список pgsql-general
Hi,

On 2019-01-22 14:18:12 +0100, Josef Machytka wrote:
> Hello, I already tried to ask on stackoverflow but so far without success.
> (
> https://stackoverflow.com/questions/54292816/postgresql-logical-replication-depends-on-wal-segments
> )
> 
> Could someone help me please?
> 
> ****
> 
> I am successfully using logical replication between 2 PG 11 cloud VMs for
> latest data. But I tried to publish also some older tables to transfer data
> between databases and got strange error about missing WAL segment.

That ought not to happen, logical replication won't start in the past,
and the slot will prevent necessary WAL from being removed.  Are you
manually removing WAL from pg_wal/?


Greetings,

Andres Freund


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

Предыдущее
От: Jeremy Finzel
Дата:
Сообщение: Re: PostgreSQL logical replication depends on WAL segments?
Следующее
От: Andres Freund
Дата:
Сообщение: Re: PostgreSQL logical replication depends on WAL segments?