Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1rUT6O-00B5tY-NL
	for pgsql-admin@arkaria.postgresql.org; Mon, 29 Jan 2024 14:59:13 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1rUT6N-00ErMy-SD
	for pgsql-admin@arkaria.postgresql.org; Mon, 29 Jan 2024 14:59:11 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <dirk.krautschick@googlemail.com>)
	id 1rUT3c-00EmAA-Gb
	for pgsql-admin@lists.postgresql.org; Mon, 29 Jan 2024 14:56:20 +0000
Received: from mail-ej1-x629.google.com ([2a00:1450:4864:20::629])
	by magus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.94.2)
	(envelope-from <dirk.krautschick@googlemail.com>)
	id 1rUT3Y-004Lwo-5X
	for pgsql-admin@lists.postgresql.org; Mon, 29 Jan 2024 14:56:19 +0000
Received: by mail-ej1-x629.google.com with SMTP id
 a640c23a62f3a-a34c5ca2537so304436566b.0
        for <pgsql-admin@lists.postgresql.org>;
 Mon, 29 Jan 2024 06:56:16 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=googlemail.com; s=20230601; t=1706540175; x=1707144975;
 darn=lists.postgresql.org;
        h=content-transfer-encoding:in-reply-to:from:references:to:subject
         :user-agent:mime-version:date:message-id:from:to:cc:subject:date
         :message-id:reply-to;
        bh=6lo8BMe9C5iLzNU2Ll0TS7P4zH10efyJs2a4uws3nKM=;
        b=kIoV/iGULFNT8OPrRdZm/0JYjFqBc0u2Y3/DxUvn6EdRMSzZlBHfxYWNGcfnBOI3Rr
         ZgGQ3ubb++oNo+waeV/fvSiW2c9lXiR7bKzHu+NuweWFqLvQdvpgUqi+3isWUKPFCL4A
         PNh8kf9MUe7EpN2hlK71rOzMzC5lvYxXNXd5L4LkDhiJ2jJxLHwbHJg2QjGzFsKjCvbY
         l8PyUT/Aomu9xZeFwYsRNvapSjPtJ3OPVHA34I3V61PNn4VmnFwa2hWD2vKIiKgc+aPJ
         543E9kmYxT+UvOURGTy45MGe479sHfupc2v3q3HA+aRxRIxovq+UIYOJdlXptEmnoATI
         f1cA==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1706540175; x=1707144975;
        h=content-transfer-encoding:in-reply-to:from:references:to:subject
         :user-agent:mime-version:date:message-id:x-gm-message-state:from:to
         :cc:subject:date:message-id:reply-to;
        bh=6lo8BMe9C5iLzNU2Ll0TS7P4zH10efyJs2a4uws3nKM=;
        b=cjLsJAA9eXqwmDHeVmScTgHcUAgNR8MZhE3Tb1vZTFyFew08TtiPP/7hTNk+3x6Ceb
         f3DHPqVp1D16NxqChXBHmer3kj8T7kLTkmauDdCcQoqZ8GTNj/KTmJXpHxBt9D5GvtLe
         1THhar2WVaXVKkaR4364bIHiJkyiF0z+fP3yiSVt2ZZKLzUBqK6DDlFcxAwCCfvJVaQu
         pGP8Vv9BBH8QCP7L13Wc7z7etWzD06cCMHwHiRNy2KvY+aMJbSskTDdwC22etSP90BzG
         tkZvhWz9RXAoPcalB/3X+AvyP/8S/joFfeKUDsVNO4TTojpkEuwmf+o7GeD87zFSGSeX
         Fk1A==
X-Gm-Message-State: AOJu0YwNVUTXCr+++PsDCPUDufpv/Lw++LiwsTvXrzuVdYU6EReUTRfV
	E/3R0cvKlskmZPsSYgyGJeJdhQ55bsMkCYKyMQuJNDWLKVNFEFE/CpvpIDe9+jw=
X-Google-Smtp-Source: 
 AGHT+IEPf8On2muhXAiopbq2tYmvO9eXNBXXe+twLICCioeSD8eQ670XNU7fk6+e2dfqm8WTjC39iQ==
X-Received: by 2002:a17:906:c446:b0:a35:e5f4:fef7 with SMTP id
 ck6-20020a170906c44600b00a35e5f4fef7mr1140623ejb.68.1706540174989;
        Mon, 29 Jan 2024 06:56:14 -0800 (PST)
Received: from ?IPV6:2a02:908:1010:f880:1553:74a6:2428:9a92?
 ([2a02:908:1010:f880:1553:74a6:2428:9a92])
        by smtp.gmail.com with ESMTPSA id
 y9-20020a170906070900b00a35a3e2b90asm1551587ejb.149.2024.01.29.06.56.14
        for <pgsql-admin@lists.postgresql.org>
        (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128);
        Mon, 29 Jan 2024 06:56:14 -0800 (PST)
Message-ID: <e8a8d645-3ac2-4673-a484-96c0dfb47bea@googlemail.com>
Date: Mon, 29 Jan 2024 15:56:13 +0100
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: pg_repack vs. running logical/physical replication
To: Pgsql-admin <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>
From: Dirk Krautschick <dirk.krautschick@googlemail.com>
In-Reply-To: 
 <CANzqJaB7sWG9PKJ3-=PXMwLRJEg9SNKmLcE_VxkBe-BxF=ijuQ@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/e8a8d645-3ac2-4673-a484-96c0dfb47bea%40googlemail.com>
Precedence: bulk

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


Thanks and best regards


Dirk