Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1puvJZ-0008Ro-Th for pgsql-hackers@arkaria.postgresql.org; Fri, 05 May 2023 13:17:38 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1puvJY-0003E5-Tt for pgsql-hackers@arkaria.postgresql.org; Fri, 05 May 2023 13:17:36 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1puvJY-0003Dv-Jo for pgsql-hackers@lists.postgresql.org; Fri, 05 May 2023 13:17:36 +0000 Received: from mail-lf1-x12f.google.com ([2a00:1450:4864:20::12f]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1puvJV-000jln-Hj for pgsql-hackers@lists.postgresql.org; Fri, 05 May 2023 13:17:36 +0000 Received: by mail-lf1-x12f.google.com with SMTP id 2adb3069b0e04-4f00c33c3d6so2052103e87.2 for ; Fri, 05 May 2023 06:17:33 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=fortnox.se; s=google; t=1683292652; x=1685884652; h=content-language:in-reply-to:to:references:reply-to:subject:from :user-agent:mime-version:date:message-id:from:to:cc:subject:date :message-id:reply-to; bh=jTKSvJbr8OdNiq4nULz7jBK5OblsjxNcBKrnMivrEV8=; b=MxAAIU5ifbfsJb6067RdQpJYOGamIK3Re0OVTNKd1dUxzZomXvTJTPYLeXeh0EEPZ1 Iy0cMTPD65gVx+Df2uRNdu0NnHyzHxax2lm+ZxtQZWXMAu5lBSzQiwsqbF96/T4mdOXr n0RDrFMm6VyzUT8yCp06ZcNbjqnlYJ4mKLdUWwI3qIx0oeCkVwDy/A49b9QEmgMCTP19 S4oUP3uGhKEyBcVTpdGKK+9ZDV0lJaQ8c/Kc2U1aVBRlaa5GNf20IS0iXS+i64uqvCpn B4W6VLRN3KqBSzklUgIJ9eVHPPmEN5GKx+PpUU/48BDi5szzUFzg64CwjAs49qD8aIgQ Y0iw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1683292652; x=1685884652; h=content-language:in-reply-to:to:references:reply-to:subject:from :user-agent:mime-version:date:message-id:x-gm-message-state:from:to :cc:subject:date:message-id:reply-to; bh=jTKSvJbr8OdNiq4nULz7jBK5OblsjxNcBKrnMivrEV8=; b=AAFCudWb8h4QiCuTboWWaNaLKyDUf2HLzGW6d3JA3A49UIrVsk1hAbcRCtccbHDR4a 5aFiy10nCTPcIvcGduTGYRMO0NMQrsv2XJHzHeoeHur+LUwzqA/Nx6QpH/oNnmCy+YuV mAsgQWoxODZ2RrmiMQB1jZx/I6e/vkzpIO9HN6pQ62snfXfSHJCkEVvbXWS8WBKv640V JCKEIGJ47VdB+QG5fZ8wfrjgj5FB+eorfXh0SVGiufdEt1Nq55ntlo5WVXqRgfx+Jdp7 Vm1Aw6UDpZP9z19F5QgeMvGDUTiTTOZFES8XI3buApkNS/EZQlctmtLUrE64vQoycdHs oiEA== X-Gm-Message-State: AC+VfDzpm8G/jTU9FsXyFcgOqdHTANQIDz0pSHzjSkZDZBrYDtVIMavk 2EpooZFp7cPnC60B57FDsGbrfIhLPmNpZaZDCOk2mh+AI6hr/zwLLVeYMWRtAXHkwGL+W4C5TuR Xo28dNvjUyR5vevRv+qDMMVXmezNxmtZ0NQOXix8= X-Google-Smtp-Source: ACHHUZ5RjHaLWW5YuFVVLsoQKR5nAwZTRsJoE6YUNVLEAC8lrmIIhuNljsNAI1wCYfkKDdpF5tViFw== X-Received: by 2002:ac2:4e62:0:b0:4f0:80:d0c0 with SMTP id y2-20020ac24e62000000b004f00080d0c0mr537329lfs.63.1683292651941; Fri, 05 May 2023 06:17:31 -0700 (PDT) Received: from [10.100.124.13] (static-212-247-234-236.cust.tele2.se. [212.247.234.236]) by smtp.gmail.com with ESMTPSA id s17-20020ac25fb1000000b004f14898d18esm283864lfe.85.2023.05.05.06.17.31 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Fri, 05 May 2023 06:17:31 -0700 (PDT) Message-ID: <807bdf85-61ea-88e2-5712-6d9fcd4eabff@fortnox.se> Date: Fri, 5 May 2023 15:17:31 +0200 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.10.0 From: =?UTF-8?Q?Robert_Sj=c3=b6blom?= Subject: [DOC] Update ALTER SUBSCRIPTION documentation Reply-To: =?UTF-8?Q?Robert_Sj=c3=b6blom?= References: <983fb847-fbd6-08d2-8199-1056cad43c6c@fortnox.se> To: pgsql-hackers@lists.postgresql.org In-Reply-To: <983fb847-fbd6-08d2-8199-1056cad43c6c@fortnox.se> Content-Type: multipart/mixed; boundary="------------nkUI4o9N3LcxaWLDXs66tFyf" Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------nkUI4o9N3LcxaWLDXs66tFyf Content-Type: text/plain; charset="UTF-8"; format=flowed Content-Transfer-Encoding: quoted-printable Hi, We have recently used the PostgreSQL documentation when setting up our=20 logical replication. We noticed there was a step missing in the=20 documentation on how to drop a logical replication subscription with a=20 replication slot attached. We clarify the documentation to include prerequisites for running the=20 DROP SUBSCRIPTION command. Please see attached patch. Best regards, Robert Sj=C3=B6blom, Oscar Carlberg --=20 Inneh=C3=A5llet i detta e-postmeddelande =C3=A4r konfidentiellt och avsett = endast f=C3=B6r=20 adressaten.Varje spridning, kopiering eller utnyttjande av inneh=C3=A5llet = =C3=A4r=20 f=C3=B6rbjuden utan till=C3=A5telse av avs=C3=A4ndaren.=C2=A0Om detta medde= lande av misstag=20 g=C3=A5tt till fel adressat v=C3=A4nligen radera det ursprungliga meddeland= et och=20 underr=C3=A4tta avs=C3=A4ndaren via e-post --------------nkUI4o9N3LcxaWLDXs66tFyf Content-Type: text/x-patch; charset=UTF-8; name="v1-doc-update-replication-slot-disable.patch" Content-Disposition: attachment; filename="v1-doc-update-replication-slot-disable.patch" Content-Transfer-Encoding: base64 ZGlmZiAtLWdpdCBhL2RvYy9zcmMvc2dtbC9yZWYvZHJvcF9zdWJzY3JpcHRpb24uc2dtbCBi L2RvYy9zcmMvc2dtbC9yZWYvZHJvcF9zdWJzY3JpcHRpb24uc2dtbAppbmRleCA4ZDk5N2M5 ODNmLi44MWIzMDUxMDcwIDEwMDY0NAotLS0gYS9kb2Mvc3JjL3NnbWwvcmVmL2Ryb3Bfc3Vi c2NyaXB0aW9uLnNnbWwKKysrIGIvZG9jL3NyYy9zZ21sL3JlZi9kcm9wX3N1YnNjcmlwdGlv bi5zZ21sCkBAIC04Niw4ICs4NiwxMCBAQCBEUk9QIFNVQlNDUklQVElPTiBbIElGIEVYSVNU UyBdIDxyZXBsYWNlYWJsZSBjbGFzcz0icGFyYW1ldGVyIj5uYW1lPC9yZXBsYWNlYWJsZQog ICAgZWl0aGVyIGJlY2F1c2UgdGhlIHJlbW90ZSBob3N0IGlzIG5vdCByZWFjaGFibGUgb3Ig YmVjYXVzZSB0aGUgcmVtb3RlCiAgICByZXBsaWNhdGlvbiBzbG90IGNhbm5vdCBiZSBkcm9w cGVkIG9yIGRvZXMgbm90IGV4aXN0IG9yIG5ldmVyIGV4aXN0ZWQsCiAgICB0aGUgPGNvbW1h bmQ+RFJPUCBTVUJTQ1JJUFRJT048L2NvbW1hbmQ+IGNvbW1hbmQgd2lsbCBmYWlsLiAgVG8g cHJvY2VlZCBpbgotICAgdGhpcyBzaXR1YXRpb24sIGRpc2Fzc29jaWF0ZSB0aGUgc3Vic2Ny aXB0aW9uIGZyb20gdGhlIHJlcGxpY2F0aW9uIHNsb3QgYnkKLSAgIGV4ZWN1dGluZyA8bGl0 ZXJhbD5BTFRFUiBTVUJTQ1JJUFRJT04gLi4uIFNFVCAoc2xvdF9uYW1lID0gTk9ORSk8L2xp dGVyYWw+LgorICAgdGhpcyBzaXR1YXRpb24sIGZpcnN0IGRpc2FibGUgdGhlIHN1YnNjcmlw dGlvbiB3aXRoCisgICA8bGl0ZXJhbD5BTFRFUiBTVUJTQ1JJUFRJT04gLi4uIERJU0FCTEU8 L2xpdGVyYWw+LiAgVGhlbiBkaXNhc3NvY2lhdGUgdGhlCisgICBzdWJzY3JpcHRpb24gZnJv bSB0aGUgcmVwbGljYXRpb24gc2xvdCBieSBleGVjdXRpbmcKKyAgIDxsaXRlcmFsPkFMVEVS IFNVQlNDUklQVElPTiAuLi4gU0VUIChzbG90X25hbWUgPSBOT05FKTwvbGl0ZXJhbD4uCiAg ICBBZnRlciB0aGF0LCA8Y29tbWFuZD5EUk9QIFNVQlNDUklQVElPTjwvY29tbWFuZD4gd2ls bCBubyBsb25nZXIgYXR0ZW1wdCBhbnkKICAgIGFjdGlvbnMgb24gYSByZW1vdGUgaG9zdC4g IE5vdGUgdGhhdCBpZiB0aGUgcmVtb3RlIHJlcGxpY2F0aW9uIHNsb3Qgc3RpbGwKICAgIGV4 aXN0cywgaXQgKGFuZCBhbnkgcmVsYXRlZCB0YWJsZSBzeW5jaHJvbml6YXRpb24gc2xvdHMp IHNob3VsZCB0aGVuIGJlCg== --------------nkUI4o9N3LcxaWLDXs66tFyf--