From: | Achilleas Mantzios <a(dot)mantzios(at)cloud(dot)gatewaynet(dot)com> |
---|---|
To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | Re: pg_repack vs. running logical/physical replication |
Date: | 2024-01-29 19:27:05 |
Message-ID: | 322e64e0-7cc4-4a1c-945b-64244b5c333e@cloud.gatewaynet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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)
From | Date | Subject | |
---|---|---|---|
Next Message | Ron Johnson | 2024-01-30 01:00:53 | Re: pg_repack vs. running logical/physical replication |
Previous Message | Dirk Krautschick | 2024-01-29 14:56:13 | pg_repack vs. running logical/physical replication |