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.96) (envelope-from ) id 1vx4N1-00DfjI-08 for pgsql-admin@arkaria.postgresql.org; Mon, 02 Mar 2026 14:35:39 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vx4M0-001I0c-1a for pgsql-admin@arkaria.postgresql.org; Mon, 02 Mar 2026 14:34:36 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vx4M0-001I0N-0P for pgsql-admin@lists.postgresql.org; Mon, 02 Mar 2026 14:34:36 +0000 Received: from mail-wm1-x334.google.com ([2a00:1450:4864:20::334]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vx4Ly-000000001vW-3kYd for pgsql-admin@lists.postgresql.org; Mon, 02 Mar 2026 14:34:35 +0000 Received: by mail-wm1-x334.google.com with SMTP id 5b1f17b1804b1-4806cc07ce7so51269765e9.1 for ; Mon, 02 Mar 2026 06:34:34 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1772462072; x=1773066872; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=/hxrQxLEFw4eElrO5u0M+TwHbRL1jWIDjcbhOG6ZeUU=; b=EYl+N7aR8/bRYv1f2oV+u+0EtphFpHlRHEGJ88Axalje34JY5Ya/ZVerwcpLuE9Lbr JxrQmZcAGAMbbSNxWa7keaJuIO3qs5R5zU9iHwKgcqaVpmNZIjVLcNjjPW42kn2cwpEg u/S80ScMC7tY+hPRFePSFH6OOc+ekDla6EqnqGda4LiKBehTcAVslc908ybhhhTtAqKv GDX8oj2vO+HfpLSOafrQgL3iduWPuOee1hUW64sNdAqJ8gDH07uykICT/UUXpywQSyfD NLATKqq6l/a6+e4YajRyjfpJOwvhR7+IlZxvqyrOjamsSMiGCXZh6hWYSlCktIOjwJsN rCdA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1772462072; x=1773066872; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=/hxrQxLEFw4eElrO5u0M+TwHbRL1jWIDjcbhOG6ZeUU=; b=k7esrGZhS6LACrqoe/PitWbUUMID6wRSSzi8hWjymf59WXIA6Q6LYguxf4wsRQWdNr DRkYMAMi+PAt+61pIFtG8PlioWARo1ikOeI9tCD3pJyNLm8f6/U3FV/BW18br8MXxsAk h2eOsCBtp27QKrlHNVrSc+Kye2lTnXvApVrcuG64DeAP4PxktoP42htBm1sVfv+IxvvM 1YQzMrFG/GrAUEX/mAv0N1N+BlG5DWiZi27f9vhXcG9qaDu5WgH3BX+afwp/7HF5kE1D HkRHsXd6AHd0gfxmu8plgGga5M2hHo+oW0TVDfrRjDVIPwZsuCGvskjflAC2XMyZKf33 R1Lw== X-Forwarded-Encrypted: i=1; AJvYcCWVt8DlORVFbsrCxt8qibiJEWfGtPuVbHlxht3IwHjUiyT+1PhFls39UAxAeApvT/2JElUbjNKWzPjfwg==@lists.postgresql.org X-Gm-Message-State: AOJu0YzQFTLgTrPLFSEiKvV9l2OfeEN11IGWD/ZuE2zmGGir5vPBPwT6 g649Hwg7Ttn+/5fa6mFPpZrA4vNpFQS+yiW5wNljtqIZ/7BM4ilFolH5YT+mWGqBmAI7eJb6EHe oqUt5xLk= X-Gm-Gg: ATEYQzzHPslriIbwvIP3BfUD9BWInd1P+P1x6IMXpFuVmq5iE9KlDUiYeCvVfCWcnow Ctj70+DX/8WBbgG2OZd/aFJxRoos3y+fDn0IoRi0J1j7jmOmenE/6vtaLoniPcu9kEZ5CUOk9Cy Ry3mhIS08Zi0VhMWZH5oSCBu+oasS2zdlM14euaf7S2T0ZQGqNNkPPKqFsUdr6jIGWzzACD+XcY Lj0ZJjcYdIRp4gbs7cQDVOcn1CJMCCLMDwW66PNMnCmNWE8lt1t1TZobOrxMVVkGTYTe5/Q6c8t 0zs06bJXGyWF1l9pZukTejeiqazX3Mq3pavwk/i9933GuoeKk+t5Y4VLrYe+QmMMDmP7EbfSX28 W1IotT+zGw9phTss4+kt+EG8hihbkJ8lxDCzOkmt3ak/q8W/DCGSb82rCMsuQ/JLvBo06Imok34 0gIyuFju+oOqNV55OaQO6aAE7AVvBity9OlV3AnT0lLqfeZgF11OE= X-Received: by 2002:a05:600c:c04b:10b0:483:79a6:e7e1 with SMTP id 5b1f17b1804b1-483c9ba7e28mr158112885e9.7.1772462071506; Mon, 02 Mar 2026 06:34:31 -0800 (PST) Received: from laurenz.albe-K4N0CV00F97414D ([2001:871:70:b332:d53:f4c8:5267:7bfa]) by smtp.gmail.com with ESMTPSA id 5b1f17b1804b1-483c3b3471asm306239035e9.3.2026.03.02.06.34.30 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 02 Mar 2026 06:34:31 -0800 (PST) Message-ID: Subject: Re: upgrade from 13 to 16 From: Laurenz Albe To: listy , Pgsql-admin Date: Mon, 02 Mar 2026 15:34:30 +0100 In-Reply-To: <7e69fa35-05c7-4cd9-9eba-90fd78b7cd18@localities.work> References: <7e69fa35-05c7-4cd9-9eba-90fd78b7cd18@localities.work> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.58.3 (3.58.3-1.fc43) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, 2026-03-02 at 13:43 +0100, listy wrote: > Is upgrade from ver. 13 to 16 possible? Yes. > -> $ sudo -u postgres pg_upgrade -D /var/lib/pgsql/data/ > You must identify the directory where the old cluster binaries reside.Ple= ase use the -b command-line option or the PGBINOLD environment variable. > Failure, exiting > > Or is a restoration from a backup the only way? >=20 > If you cannot be bothered to read the documentation for pg_upgrade, then dump and restore may be the only way. Yours, Laurenz Albe