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.94.2) (envelope-from ) id 1qQ5ID-00CtFy-5B for pgsql-general@arkaria.postgresql.org; Sun, 30 Jul 2023 12:13:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qQ5IB-00971d-Ai for pgsql-general@arkaria.postgresql.org; Sun, 30 Jul 2023 12:12:59 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qQ5IB-00971V-03 for pgsql-general@lists.postgresql.org; Sun, 30 Jul 2023 12:12:59 +0000 Received: from mail-yb1-xb33.google.com ([2607:f8b0:4864:20::b33]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qQ5I4-001GnB-9O for pgsql-general@lists.postgresql.org; Sun, 30 Jul 2023 12:12:58 +0000 Received: by mail-yb1-xb33.google.com with SMTP id 3f1490d57ef6-d0728058651so3770802276.1 for ; Sun, 30 Jul 2023 05:12:51 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1690719170; x=1691323970; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:from:to:cc:subject:date:message-id :reply-to; bh=rzqByMD8hKyhV873LV0tSCK/4wYFHiTGx8m17l/bGY0=; b=fCDVEX9iOrB8IdjF4+3toOr5lLZuSL9GsCF2Uo1JP9BUj89ZcaABsamIrkrW3grOx5 ahiXvKjxDm4nie4tMVpFlBZ7gv4Km0za7i/A3zmIopyBHrMiAN5Z0ljFte1NpGMW6lKE 7bQgG2uVDBoNEjS47kDNLxIAFXZilyVeu2QrdihWGc8DF+biNgTddpxFdoPC14eF/g34 dtnZlmQ8Q0eSbaBZimZrUGRs16ECG2jicl/zeuRo2nmTf1u8ECI/Vb1rijy53VIAqDg+ Ln3pisV0gilAFitASgmirzLsfCMW7v/qicmrpApW9QD7M9ez+O2PLVwVmlje96s3Ek2z L0Vw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1690719170; x=1691323970; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:x-gm-message-state:from:to:cc:subject :date:message-id:reply-to; bh=rzqByMD8hKyhV873LV0tSCK/4wYFHiTGx8m17l/bGY0=; b=AQSwwnvcz0NX0nA7GLP4xq/Ax22Fs0xcWcTuM7TUQMHzZR/C1snluS2PdKdXpOUp/8 rLF8rQOtrzthl6v83G1Y2RrYKCPKkAdzBK+XjnexxkOaiEU8GDkGfvgqzmvQh1K0Xi3f dKsl1ohRGVj604JBVqR8+4yQ1fg+J89ghdU0FOftdGphLsBLB+2EkfmlsQrQEyNfaRbH Ddacl70l7XwSsBYsH4Q8f53m4KNbCIlMKO5jYRxpeuNPwJkQvh6b0+mkeKg9aOL4MW5K 58H1xZV8BbWXCNntjNXQSdOIwESxgAfDp1w97yC6Be887cPtjpxQt8zzZQgVgWbv6JhK 39vg== X-Gm-Message-State: ABy/qLZVzpsEbBQcpeaM8RQxAFIaBOZ0zjcT2TLslNxiqsdiwpMjjFmQ ky+XFJXyYyAGYaRnIG1b7N+pc5w5obQ= X-Google-Smtp-Source: APBJJlHQYIqvjzwZ2EQWscQuwLzLUuNnwk7m0AZtXjGlvpJ2jm9ccDfl2PQeU31UMpK9nllkgswoSA== X-Received: by 2002:a25:ab12:0:b0:d29:d2ab:6eda with SMTP id u18-20020a25ab12000000b00d29d2ab6edamr7560422ybi.1.1690719170045; Sun, 30 Jul 2023 05:12:50 -0700 (PDT) Received: from ?IPV6:2600:1700:bd2c:b810:9cea:c878:3644:a2fd? ([2600:1700:bd2c:b810:9cea:c878:3644:a2fd]) by smtp.googlemail.com with ESMTPSA id n186-20020a25d6c3000000b00ca519aa8cf7sm1902495ybg.39.2023.07.30.05.12.49 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Sun, 30 Jul 2023 05:12:49 -0700 (PDT) Content-Type: multipart/alternative; boundary="------------nVyuR0C9w0XyLbNWtCvkqWNa" Message-ID: <03aafbb2-21e4-2f72-1ed9-fc91c08c9f15@gmail.com> Date: Sun, 30 Jul 2023 07:12:49 -0500 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.11.0 Subject: Re: Upgrading Content-Language: en-US To: pgsql-general@lists.postgresql.org References: <2426dfb5-63f7-a166-5780-5433da798a9e@gmail.com> From: Ron In-Reply-To: <2426dfb5-63f7-a166-5780-5433da798a9e@gmail.com> 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. --------------nVyuR0C9w0XyLbNWtCvkqWNa Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit On 7/30/23 06:53, Amn Ojee Uw wrote: > Just a quick question. > > On my Debian 12, I installed PostgreSQL-12, I'd like to upgrade to the > latest release of PostgreSQL. So, my question is, what is the best way to > upgrade to the next release of PostgreSQL? To the latest release of v12 (which is 12.15), or the latest major version (v15, at release 15.3)? "Upgrade" has a specific meaning in PostgreSQL: to migrate from a prior *major* (like 12) version to a newer major (like 15) version. Is that what you mean? Or did you mean to *update* from an older release of v12 (for example 12.11) to the latest release (12.15)? -- Born in Arizona, moved to Babylonia. --------------nVyuR0C9w0XyLbNWtCvkqWNa Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit On 7/30/23 06:53, Amn Ojee Uw wrote:
Just a quick question.

On my Debian 12, I installed PostgreSQL-12, I'd like to upgrade to the latest release of PostgreSQL. So, my question is, what is the best way to upgrade to the next release of PostgreSQL?

To the latest release of v12 (which is 12.15), or the latest major version (v15, at release 15.3)?

"Upgrade" has a specific meaning in PostgreSQL: to migrate from a prior major (like 12) version to a newer major (like 15) version.

Is that what you mean?

Or did you mean to update from an older release of v12 (for example 12.11) to the latest release (12.15)?

--
Born in Arizona, moved to Babylonia.
--------------nVyuR0C9w0XyLbNWtCvkqWNa--