Re: pg_repack vs. running logical/physical replication - Mailing list pgsql-admin

From Achilleas Mantzios
Subject Re: pg_repack vs. running logical/physical replication
Date
Msg-id 322e64e0-7cc4-4a1c-945b-64244b5c333e@cloud.gatewaynet.com
Whole thread Raw
In response to pg_repack vs. running logical/physical replication  (Dirk Krautschick <dirk.krautschick@googlemail.com>)
Responses Re: pg_repack vs. running logical/physical replication
List pgsql-admin
Στις 29/1/24 16:56, ο/η Dirk Krautschick έγραψε:
> Hi,
>
>
> is there any good reason to cut of logical and/or physical replication 
> for the time pg_repack (please no discussion about pg_repack at all, 
> customer request, his idea, his strict wish) is running? I am not so 
> deep into how pg_repack is running things but as the docs are saying 
> it could affect hard at least the publications for logrep. Haven't 
> tested it yet and just hopeing for a quick answer here :-)

Why should logical replication break?

Why would you want to fill your repl slots (if any) by suspending 
physical replication while pg_repack runs?

I would advise reading about pg_repack and/or testing yourself to see 
how it works.

>
>
> Thanks and best regards
>
>
> Dirk
>
>
>
-- 
Achilleas Mantzios
  IT DEV - HEAD
  IT DEPT
  Dynacom Tankers Mgmt (as agents only)




pgsql-admin by date:

Previous
From: Dirk Krautschick
Date:
Subject: pg_repack vs. running logical/physical replication
Next
From: Ron Johnson
Date:
Subject: Re: pg_repack vs. running logical/physical replication