Postgres Pro
Downloads
Home   >   mailing lists

Re: Logical replication - Mailing list pgsql-general

From Javi Legido
Subject Re: Logical replication
Date
Msg-id CALbe0QUYnq+xmpJPAxkQHeMayW=yxWLKDcayJihoWK47wWbuAg@mail.gmail.com
Whole thread Raw
In response to Re: Logical replication  (Joshua Drake <jd@commandprompt.com>)
List pgsql-general
Tree view
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 by date:

Previous
From: Joshua Drake
Date:
Subject: Re: Logical replication
Next
From: Matthias Apitz
Date:
Subject: ESQL/C no indicator variables ./. error -213