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
>>
>
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 |