Re: BUG #18027: Logical replication taking forever - Mailing list pgsql-bugs

From vignesh C
Subject Re: BUG #18027: Logical replication taking forever
Date
Msg-id CALDaNm3HTNTrQ3e09TiaE_WwYppDYXmwr99oXc2VrTNO9UTXag@mail.gmail.com
Whole thread Raw
In response to Re: BUG #18027: Logical replication taking forever  (Andres Martin del Campo Campos <andres@invisible.email>)
Responses Re: BUG #18027: Logical replication taking forever
List pgsql-bugs
On Wed, 19 Jul 2023 at 14:06, Andres Martin del Campo Campos
<andres@invisible.email> wrote:
>
> Thank you so much for replying, I'm really struggling here.
>
> I ran out of space and I thought I could re-start it to see if it worked but again it's been more than a day and it
isn'tshowing.
 
>

Can you run this query few times on the publisher and see if
bytes_processed and tuples_processed are getting increased(this might
give us some hint if it stuck or it is progressing slowly):
SELECT * FROM pg_stat_progress_copy;

If it is not progressing, is there anything unusual in the log file,
some warning or error messages? if so could you post those log
contents too.
Also if it is stuck, how many tuples are copied and how much is the
total tuple count?

Regards,
Vignesh



pgsql-bugs by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: BUG #18030: Large memory consumption caused by in-clause subqueries
Next
From: PG Bug reporting form
Date:
Subject: BUG #18031: Segmentation fault after deadlock within VACUUM's parallel worker