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 1pWhUr-0005YB-7J for pgsql-general@arkaria.postgresql.org; Mon, 27 Feb 2023 17:41:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pWhUo-0007bL-LR for pgsql-general@arkaria.postgresql.org; Mon, 27 Feb 2023 17:41:06 +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 1pWhUo-0007b5-7S for pgsql-general@lists.postgresql.org; Mon, 27 Feb 2023 17:41:06 +0000 Received: from mail-ed1-x52e.google.com ([2a00:1450:4864:20::52e]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pWhUi-0003Ff-GX for pgsql-general@postgresql.org; Mon, 27 Feb 2023 17:41:05 +0000 Received: by mail-ed1-x52e.google.com with SMTP id s26so28937319edw.11 for ; Mon, 27 Feb 2023 09:41:00 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20210112.gappssmtp.com; s=20210112; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:from:to:cc:subject :date:message-id:reply-to; bh=/Ykv6GnXk2cPyqQOKN9dyxECwIXwE/eqesA7i7nfNI4=; b=vFSBrgaetZnj39c77ziVXJd5liMcrqif+begEfZag61SR2NMA5fJ5HdpDSxFGn1nhk PdKA7ad2jx4LjiIz894MyPVq4GckBKYEkvc5GvjTiHKn680ezKeaQR40oLDjLYokZcWv TzfTpdsPJzfq8iEbYISWzjV1rTR9vdlbhoGSWt64ND+3RzX898AwTlgBbZkXHVYgnRE2 jw8cJJ48spNbQAkeIIztapmXd6ehD2facZ/8o2GLVwIvQebKC2LFCynJOabe/OkteFcS bqNz/HG4X9RTPWPooyUUbK6vUpu66aAW+6fMYfrfJ2PyMCkyDS7WGRGTR0rDAUMq5iRf ZRMg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=/Ykv6GnXk2cPyqQOKN9dyxECwIXwE/eqesA7i7nfNI4=; b=I+DRSHrCAlO+C4eTU3Dp0mmOtTWIUjkpa0VCz6jByEuWtdejCayFsuMVoSNUea43ZE H7woO7I/Wb2Akxs5InP6iw8lpB20SD64dHct9n3IguuO9Ck5XK+/XZb2odv7rtYq/nRW hqLPqx24NQOGzkA8WoBm/r4Ovxmr4rLJdKGRQlBkXFvSRIOz2XDzAp3KkMhcmQduvn8W MU/SSyRrlIKcqnbWO2vU3PMGV0D4Yt5s5Gq9S5P+pkcbdMpwizJSAdBVQkdKLkvvbF5b BPci9N47+YicZUXkuNUymxIpzKn6ipLkDRHAF5hZsNNT2B14tMxBUNFdHnNibyKo0vWN IviQ== X-Gm-Message-State: AO0yUKUH9OX13v7YL/d3EF6f8ugpkrSpcRkPr9Q5bVhiNrcVA8thyqqF KzaU4J3UXMjz03AEjIK7Gkm6Kg== X-Google-Smtp-Source: AK7set+lv9QLmK9xcdZqZ4evhDh/pEAkhr4DlEooxeGlC2+vtDSW7jDQu9hG0u5vTaPj7whxvZYNeQ== X-Received: by 2002:a05:6402:3898:b0:4b6:821e:1859 with SMTP id fd24-20020a056402389800b004b6821e1859mr2558508edb.7.1677519659197; Mon, 27 Feb 2023 09:40:59 -0800 (PST) Received: from dynamic-pd01.res.v6.highway.a1.net ([2001:871:5e:539:1b2c:c52a:475d:310c]) by smtp.gmail.com with ESMTPSA id n15-20020a5099cf000000b004aef147add6sm3382203edb.47.2023.02.27.09.40.58 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 27 Feb 2023 09:40:58 -0800 (PST) Message-ID: Subject: Re: pg_upgradecluster transfering only a portion of the data From: Laurenz Albe To: =?ISO-8859-1?Q?D=E1vid?= Suchan , Adrian Klaver Cc: pgsql-general Date: Mon, 27 Feb 2023 18:40:57 +0100 In-Reply-To: References: <88bcf9f7-3483-9d26-4a5c-984b79850833@aklaver.com> <2cc57fe7-daa8-5312-078f-3e7c0adb7606@aklaver.com> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.46.4 (3.46.4-1.fc37) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, 2023-02-27 at 18:18 +0100, D=C3=A1vid Suchan wrote: > I did not use the -k --link argument while upgrading as that I presume do= es not copy the data=C2=A0 It would be great if you shared the exact command line you used. The man page of "pg_upgradecluster" says: -m, --method=3Ddump|upgrade|link|clone Specify the upgrade method. dump uses pg_dump(1) and pg_restore(1), u= pgrade uses pg_upgrade(1). The default is dump. Yours, Laurenz Albe