Re: Logical replication

From: Javi Legido <javi(at)legido(dot)com>
To: Joshua Drake <jd(at)commandprompt(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Logical replication
Date: 2020-06-17 15:45:01
Message-ID: CALbe0QUYnq+xmpJPAxkQHeMayW=yxWLKDcayJihoWK47wWbuAg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)commandprompt(dot)com> wrote:

> Javi,
>
> What does your PostgreSQL log say about replication?
>
> JD
>
> On Wed, Jun 17, 2020 at 2:07 AM Javi Legido <javi(at)legido(dot)com> wrote:
>
>> Good morning.
>>
>> I'm testing logical replication, but after creating subscription nothing
>> happens, and I expected replication start.
>>
>> Details here: https://paste.debian.net/1152451/
>>
>> Any help will be appreciated.
>>
>> Thanks.
>>
>> Javier
>>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Matthias Apitz 2020-06-17 17:02:21 ESQL/C no indicator variables ./. error -213
Previous Message Joshua Drake 2020-06-17 15:27:22 Re: Logical replication