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 1pt7ds-0007sx-E7 for pgsql-pkg-debian@arkaria.postgresql.org; Sun, 30 Apr 2023 14:03:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pt7dp-0004uc-Es for pgsql-pkg-debian@arkaria.postgresql.org; Sun, 30 Apr 2023 14:03:05 +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 1pt7do-0004pz-Vm for pgsql-pkg-debian@lists.postgresql.org; Sun, 30 Apr 2023 14:03:05 +0000 Received: from mail-io1-xd34.google.com ([2607:f8b0:4864:20::d34]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1pt7dj-002i8L-8T for pgsql-pkg-debian@postgresql.org; Sun, 30 Apr 2023 14:03:03 +0000 Received: by mail-io1-xd34.google.com with SMTP id ca18e2360f4ac-760ec550833so135507039f.3 for ; Sun, 30 Apr 2023 07:02:59 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20221208.gappssmtp.com; s=20221208; t=1682863378; x=1685455378; h=content-disposition:mime-version:message-id:subject:to:from:date :from:to:cc:subject:date:message-id:reply-to; bh=POCDRXwLPKIz5McIq5zA5bSojYyFveK7oKl/UrcX0xI=; b=J5lC93BX/jcKwL3Bycdab6dv2JPFfySfmvjSIrJMVqCeaNkKY3d7mBovZe2qBDde1t fVJnVMIh5Fq4cbMK14Uv9dQ7EbhIbNKw+hq+/owsv3g3rHkL5ZjzgCBLZ99LRpsqgIDB 5GJvIXZBM2EWrEAPDBz98EnlOtRDk86QLS071coQwA7a5u+ycDnNdTkaKmlMyWAddKsj oie5ro2QM8JyZAVRcQd1+FKGldGlfDpb9ErxOB+rrcmsgd47vyOmv647uRTsWKgvwV5u zpskcOkFoEM0A0FAyr/+gagDIY2fs8Plqavi5Bm9xV5SfvxWk8GO6mvRgDe4biqO2bUH jZUg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1682863378; x=1685455378; h=content-disposition:mime-version:message-id:subject:to:from:date :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=POCDRXwLPKIz5McIq5zA5bSojYyFveK7oKl/UrcX0xI=; b=gagr+IIWrBvbQ/8PXa1aEuqRJB3kH7wPsFkSvcn/Jju1vze9g2SBn+5k321qfWP8os ZIAabFU47wC5dt97+c3MBZZVznvZD/ASNSqtn/gjih7PHNEz182aFVeVKPa/RM6/Ia+7 W7Co2hTZPeBgjOuOVcC5+Mxv9fmtiTjsLpzoeDM1qSh3AtdvaYRizavFtzuKxDnGCFme xenoa+lyFNJVnZUbTgVObgbXRHrNxnrNKCxd/XTVZB2/0kjs22JBewwqzoKthFlWeG0B W5TnO9msd5j3lngVgrtqOjhnnYM9O4O3JC1B8kpFpp2dZjCVUclmgVSgqCqwShSj0/0/ 6OOw== X-Gm-Message-State: AC+VfDxLoiOLnomIFhwVjl7LhhhYNIYMIPRIeKybnGtG5dKu3YONRq+A eci0x2q0EokSDI9iBfO6DLM2UUkuOcu9rA92pyg= X-Google-Smtp-Source: ACHHUZ4GxkT1sJbK0TUsO9u5Dk6lGHoB6FQWe9Jgi8cTQnPeX/9uC9aAQ9xwtmjd0cxAKhLrAxVMAw== X-Received: by 2002:a6b:fd12:0:b0:769:36b:3a51 with SMTP id c18-20020a6bfd12000000b00769036b3a51mr2591833ioi.15.1682863378483; Sun, 30 Apr 2023 07:02:58 -0700 (PDT) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id d1-20020a028581000000b004050767f779sm7752663jai.164.2023.04.30.07.02.57 for (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Sun, 30 Apr 2023 07:02:58 -0700 (PDT) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id 0314D80096E; Sun, 30 Apr 2023 09:02:56 -0500 (CDT) Date: Sun, 30 Apr 2023 09:02:56 -0500 From: Justin Pryzby To: pgsql-pkg-debian@postgresql.org Subject: postgresql-common: use latest version of pg_dump/restore Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk I added dump/restore to this list locally while updating a backup script to use -Z zstd, but it seems like this would make sense to do widely, since pg-dump/restore support a long history of versions, beyond the 5 release/years of versions nominally supported. /usr/share/postgresql-common/pg_wrapper # if we have no version yet, use the latest version. If we were called # as psql, pg_archivecleanup, or pg_isready, always use latest version if (not $version or $cmdname =~ /^(psql|pg_archivecleanup|pg_isready|pg_dump|pg_restore)$/) { -- Justin