Re: Logical replication

Поиск
Список
Период
Сортировка
От Javi Legido
Тема Re: Logical replication
Дата
Msg-id CALbe0QUYnq+xmpJPAxkQHeMayW=yxWLKDcayJihoWK47wWbuAg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Logical replication  (Joshua Drake <jd@commandprompt.com>)
Список pgsql-general
Дерево обсуждения
Many thanks for your reply.

The last line of the subscriber says:

```
2020-06-17 12:48:02.955 UTC [124] LOG:  logical replication apply worker for subscription "my_subscription" has started
```

Let's keep this on hold for a while, since I guess that it's taking longer than expected, since it's a quite big database (more than 500 GB).

Currently the pg_stat_replication.state is in 'catchup' for 2h now.

I will reply to this thread as soon as I would have any news.

Thanks again.



On Wed, 17 Jun 2020 at 17:27, Joshua Drake <jd@commandprompt.com> wrote:
Javi,

What does your PostgreSQL log say about replication?

JD

On Wed, Jun 17, 2020 at 2:07 AM Javi Legido <javi@legido.com> wrote:
Good morning.

I'm testing logical replication, but after creating subscription nothing happens, and I expected replication start.


Any help will be appreciated.

Thanks.

Javier

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

Предыдущее
От: Joshua Drake
Дата:
Сообщение: Re: Logical replication
Следующее
От: Matthias Apitz
Дата:
Сообщение: ESQL/C no indicator variables ./. error -213