Message-ID: <322e64e0-7cc4-4a1c-945b-64244b5c333e@cloud.gatewaynet.com>
Date: Mon, 29 Jan 2024 21:27:05 +0200
MIME-Version: 1.0
Subject: Re: pg_repack vs. running logical/physical replication
Content-Language: en-US
To: pgsql-admin@lists.postgresql.org
References: 
 <CANzqJaAvhK+82KyC=NJ6HGi3VhwHibSUAH2+b2T-3w9Ct4HbXQ@mail.gmail.com>
 <CA+427g9yfibEe62upmOnW7On6ixwvQbXXiLLPwT8vKAQ9p3bYQ@mail.gmail.com>
 <CAAo1mbkFD7yAARhf-oLf4ZuGSr3Xdi8-nYO=whAweKWTeTPVkg@mail.gmail.com>
 <CANzqJaB7sWG9PKJ3-=PXMwLRJEg9SNKmLcE_VxkBe-BxF=ijuQ@mail.gmail.com>
 <e8a8d645-3ac2-4673-a484-96c0dfb47bea@googlemail.com>
From: Achilleas Mantzios <a.mantzios@cloud.gatewaynet.com>
In-Reply-To: <e8a8d645-3ac2-4673-a484-96c0dfb47bea@googlemail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: 
 <https://www.postgresql.org/message-id/322e64e0-7cc4-4a1c-945b-64244b5c333e%40cloud.gatewaynet.com>
Precedence: bulk

Στις 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)