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 1kLmtw-0005bj-3O for pgsql-docs@arkaria.postgresql.org; Fri, 25 Sep 2020 12:32:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kLmtt-0003pa-Py for pgsql-docs@arkaria.postgresql.org; Fri, 25 Sep 2020 12:32:33 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kLmtt-0003ll-Gb for pgsql-docs@lists.postgresql.org; Fri, 25 Sep 2020 12:32:33 +0000 Received: from mail-ej1-x641.google.com ([2a00:1450:4864:20::641]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kLmtq-0001SH-Ko for pgsql-docs@lists.postgresql.org; Fri, 25 Sep 2020 12:32:32 +0000 Received: by mail-ej1-x641.google.com with SMTP id o8so3360748ejb.10 for ; Fri, 25 Sep 2020 05:32:30 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20150623.gappssmtp.com; s=20150623; h=message-id:subject:from:to:date:in-reply-to:references:user-agent :mime-version; bh=7oJht6FUJkS7ZgSzN9BSgwyIsWSSf4gQKlX9Ze0eB6Y=; b=yQqjZCUs5NRfL4LB+HcXRuSAXYVHPss50ALdxEKOltCjp4sLfCxAtjyuyjMb3vlFvJ 7auVGRP+3opvlBQt/yCC9L9bneLBbafrAb6OFnMqTiK/IDYljefHfNr6YiaW/0jVYYAU lUUudlSfhnRgmjpgVp8f9X58oAG69VIrV98psC1trA7rryD1YW/QJvbiDTRszc8ba79M 8lrZ7jJSajeNMFUhqqWvD8n5EiEEq9l56VjOPHcsG5ZePXvyLuAVJSCozQQWlHuCgjHT /TD5SAvGeX7UefjuZFtnK1YJbkpr3mND6m1WXRx/Ud59Nj++L3xMtccbetk8BdP7x0Jg VbLg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:message-id:subject:from:to:date:in-reply-to :references:user-agent:mime-version; bh=7oJht6FUJkS7ZgSzN9BSgwyIsWSSf4gQKlX9Ze0eB6Y=; b=JaKnpBJMPDxssOkgafo/Gj/nzIE25X+7JY74et9hupQF3iFiSf4nz/VSJNQOhpJ15p S383eaWqYrs0ThRh/28rvjsgAuFmj8+IwnB7+zGgMXywqfaDkN1TZlgdiTaD9jRZyAbG hiZMT4CklCSOZpnj4Xi3pX11GAOw1Mgu8Hi9MPdpIiws8rHT/9x87HJvwmt8NTmHrCXu mTxE73cf/e9Wm+BcMDuevIG8ps/hMk0uAAFHYxQdUk5ptnYl+3jRMmMLTh17d6oCpO90 BewjM96F5ztGthdnS/7XvwOcEzipJv2iJ2q1rTJrSUtyZBphq927BXzcf1XYgQnuxXv7 9DEw== X-Gm-Message-State: AOAM531rzIMV8QiBCh+DqEHOuKtyKXUsDHG5InB8g9ysiRDfTAsdYR2V fdMs4Nqek45v6DN3VDUEn9w4txpa1lLtOA== X-Google-Smtp-Source: ABdhPJxcCq6g++qyuWb2pOriR6ihS5HDwLQCWItItwqOLPSckzlK0tj3iGAlTz1PrRKX/UUtOTGHlA== X-Received: by 2002:a17:906:841a:: with SMTP id n26mr2444152ejx.213.1601037148814; Fri, 25 Sep 2020 05:32:28 -0700 (PDT) Received: from localhost.localdomain (217-149-169-205.nat.highway.telekom.at. [217.149.169.205]) by smtp.gmail.com with ESMTPSA id f13sm1686982edn.73.2020.09.25.05.32.27 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 25 Sep 2020 05:32:28 -0700 (PDT) Message-ID: <3e33df71449fdc083b1ed8a4dfe3ee129de59798.camel@cybertec.at> Subject: Re: Possible mistake in backup documentation From: Laurenz Albe To: abo@velvica.com, pgsql-docs@lists.postgresql.org Date: Fri, 25 Sep 2020 14:32:26 +0200 In-Reply-To: <160078426053.14061.808669930112439771@wrigleys.postgresql.org> References: <160078426053.14061.808669930112439771@wrigleys.postgresql.org> Content-Type: multipart/mixed; boundary="=-bHr+pVfiYG8SOrO/rM7X" User-Agent: Evolution 3.36.5 (3.36.5-1.fc32) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --=-bHr+pVfiYG8SOrO/rM7X Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: 7bit On Tue, 2020-09-22 at 14:17 +0000, PG Doc comments form wrote: > In "25.3.3.2. Making An Exclusive Low-Level Backup", you said that "The > exclusive backup method is deprecated and should be avoided. Prior to > PostgreSQL 9.6, this was the only low-level method available, but it is now > recommended that all users upgrade their scripts to use non-exclusive > backups". But in the example in "25.3.6.1. Standalone Hot Backups" you use > the exclusive version of backup command. Is it a mistake or not? Yes, that's true. How about the attached patch? Perhaps that is too complicated, but I have no idea how to make it simpler. Ceterum censeo, we should not deprecate the exclusive backup API. Yours, Laurenz Albe --=-bHr+pVfiYG8SOrO/rM7X Content-Disposition: attachment; filename="0001-Use-non-exclusive-backup-in-example.patch" Content-Type: text/x-patch; name="0001-Use-non-exclusive-backup-in-example.patch"; charset="UTF-8" Content-Transfer-Encoding: base64 RnJvbSAyODNmYTY0NGMxNWIwODg5NGZkZmY5NTdlNTdlNTI2Yjg1OTEzOTUxIE1vbiBTZXAgMTcg MDA6MDA6MDAgMjAwMQpGcm9tOiBMYXVyZW56IEFsYmUgPGxhdXJlbnouYWxiZUBjeWJlcnRlYy5h dD4KRGF0ZTogRnJpLCAyNSBTZXAgMjAyMCAxNDoyNjo1OCArMDIwMApTdWJqZWN0OiBbUEFUQ0hd IFVzZSBub24tZXhjbHVzaXZlIGJhY2t1cCBpbiBleGFtcGxlCgpTaW5jZSB3ZSBoYWJlIGRlcHJl Y2F0ZWQgdGhlIGV4Y2x1c2l2ZSBiYWNrdXAgQVBJLCB3ZSBzaG91bGQgbm90CnVzZSBpdCBpbiBl eGFtcGxlcy4KCkRpc2N1c3Npb246IGh0dHBzOi8vcG9zdGdyLmVzL20vMTYwMDc4NDI2MDUzLjE0 MDYxLjgwODY2OTkzMDExMjQzOTc3MUB3cmlnbGV5cy5wb3N0Z3Jlc3FsLm9yZwotLS0KIGRvYy9z cmMvc2dtbC9iYWNrdXAuc2dtbCB8IDE2ICsrKysrKysrKystLS0tLS0KIDEgZmlsZSBjaGFuZ2Vk LCAxMCBpbnNlcnRpb25zKCspLCA2IGRlbGV0aW9ucygtKQoKZGlmZiAtLWdpdCBhL2RvYy9zcmMv c2dtbC9iYWNrdXAuc2dtbCBiL2RvYy9zcmMvc2dtbC9iYWNrdXAuc2dtbAppbmRleCBiOTMzMTgz MGY3Li5kZGYyYWEzZjM1IDEwMDY0NAotLS0gYS9kb2Mvc3JjL3NnbWwvYmFja3VwLnNnbWwKKysr IGIvZG9jL3NyYy9zZ21sL2JhY2t1cC5zZ21sCkBAIC0xNDk2LDE1ICsxNDk2LDE5IEBAIGFyY2hp dmVfY29tbWFuZCA9ICd0ZXN0ICEgLWYgL3Zhci9saWIvcGdzcWwvYmFja3VwX2luX3Byb2dyZXNz IHx8ICh0ZXN0ICEgLWYgL3ZhCiAgICAgICBmb2xsb3dpbmc6CiA8cHJvZ3JhbWxpc3Rpbmc+CiB0 b3VjaCAvdmFyL2xpYi9wZ3NxbC9iYWNrdXBfaW5fcHJvZ3Jlc3MKLXBzcWwgLWMgInNlbGVjdCBw Z19zdGFydF9iYWNrdXAoJ2hvdF9iYWNrdXAnKTsiCi10YXIgLWNmIC92YXIvbGliL3Bnc3FsL2Jh Y2t1cC50YXIgL3Zhci9saWIvcGdzcWwvZGF0YS8KLXBzcWwgLWMgInNlbGVjdCBwZ19zdG9wX2Jh Y2t1cCgpOyIKLXJtIC92YXIvbGliL3Bnc3FsL2JhY2t1cF9pbl9wcm9ncmVzcwotdGFyIC1yZiAv dmFyL2xpYi9wZ3NxbC9iYWNrdXAudGFyIC92YXIvbGliL3Bnc3FsL2FyY2hpdmUvCitta2RpciAv dG1wL2RhdGEKK3BzcWwgLUF0cSAtYyAic2VsZWN0IHBnX3N0YXJ0X2JhY2t1cChsYWJlbCA9PiAn aG90X2JhY2t1cCcsIGV4Y2x1c2l2ZSA9PiBGQUxTRSk7IiBcCisgICAgICAgICAgLWMgIlwhIHRh ciAtY2YgL3Zhci9saWIvcGdzcWwvYmFja3VwLnRhciAtQyAvdmFyL2xpYi9wZ3NxbC8gZGF0YS8i IFwKKyAgICAgICAgICAtYyAiXG8gL3RtcC9kYXRhL2JhY2t1cF9sYWJlbCIgXAorICAgICAgICAg IC1jICJTRUxFQ1QgbGFiZWxmaWxlIEZST00gcGdfc3RvcF9iYWNrdXAoZXhjbHVzaXZlID0+IEZB TFNFKTsiCit0YXIgLXJmIC92YXIvbGliL3Bnc3FsL2JhY2t1cC50YXIgLUMgL3RtcCBkYXRhL2Jh Y2t1cF9sYWJlbAorcm0gLXIgL3Zhci9saWIvcGdzcWwvYmFja3VwX2luX3Byb2dyZXNzIC90bXAv ZGF0YQordGFyIC1yZiAvdmFyL2xpYi9wZ3NxbC9iYWNrdXAudGFyIC1DIC92YXIvbGliL3Bnc3Fs LyBhcmNoaXZlLwogPC9wcm9ncmFtbGlzdGluZz4KICAgICAgIFRoZSBzd2l0Y2ggZmlsZSA8Zmls ZW5hbWU+L3Zhci9saWIvcGdzcWwvYmFja3VwX2luX3Byb2dyZXNzPC9maWxlbmFtZT4gaXMKICAg ICAgIGNyZWF0ZWQgZmlyc3QsIGVuYWJsaW5nIGFyY2hpdmluZyBvZiBjb21wbGV0ZWQgV0FMIGZp bGVzIHRvIG9jY3VyLgotICAgICAgQWZ0ZXIgdGhlIGJhY2t1cCB0aGUgc3dpdGNoIGZpbGUgaXMg cmVtb3ZlZC4gQXJjaGl2ZWQgV0FMIGZpbGVzIGFyZQorICAgICAgQWZ0ZXIgdGhlIGJhY2t1cCB0 aGUgc3dpdGNoIGZpbGUgaXMgcmVtb3ZlZC4gPGZpbGVuYW1lPmJhY2t1cF9sYWJlbDwvZmlsZW5h bWU+CisgICAgICBhbmQgYXJjaGl2ZWQgV0FMIGZpbGVzIGFyZQogICAgICAgdGhlbiBhZGRlZCB0 byB0aGUgYmFja3VwIHNvIHRoYXQgYm90aCBiYXNlIGJhY2t1cCBhbmQgYWxsIHJlcXVpcmVkCiAg ICAgICBXQUwgZmlsZXMgYXJlIHBhcnQgb2YgdGhlIHNhbWUgPGFwcGxpY2F0aW9uPnRhcjwvYXBw bGljYXRpb24+IGZpbGUuCiAgICAgICBQbGVhc2UgcmVtZW1iZXIgdG8gYWRkIGVycm9yIGhhbmRs aW5nIHRvIHlvdXIgYmFja3VwIHNjcmlwdHMuCi0tIAoyLjI2LjIKCg== --=-bHr+pVfiYG8SOrO/rM7X--