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 1qQIYC-00DToi-7p for pgsql-general@arkaria.postgresql.org; Mon, 31 Jul 2023 02:22:24 +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 1qQIY9-00BZJn-I6 for pgsql-general@arkaria.postgresql.org; Mon, 31 Jul 2023 02:22:21 +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 1qQIY9-00BZJf-7G for pgsql-general@lists.postgresql.org; Mon, 31 Jul 2023 02:22:21 +0000 Received: from mail-qt1-x832.google.com ([2607:f8b0:4864:20::832]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qQIY7-001NM5-32 for pgsql-general@lists.postgresql.org; Mon, 31 Jul 2023 02:22:20 +0000 Received: by mail-qt1-x832.google.com with SMTP id d75a77b69052e-409ae93bbd0so18441691cf.0 for ; Sun, 30 Jul 2023 19:22:18 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1690770137; x=1691374937; h=in-reply-to:content-language:references:to:subject:user-agent :mime-version:date:message-id:from:from:to:cc:subject:date :message-id:reply-to; bh=5/IwxESKTp+4b5Uxm6W8imA/WVjsLKDeGwKgqhxnOBw=; b=cAnW/BdE9xc2+Ewd+AA4CURW/wShH7wzdshUJk5bmVTPt3kVeJS6cABRAVKRENFu2N mY04vD5SRST9MQmQnYm9sADRQ8TidIZYLg7QGjBaVZavrIizH+A0z5ryG/kbmVaM89St B+A9TXM8w/EmztOFEfKLInfvit7XSJOngJXd9pIoyDgoxUi8pftuFYrKDbuqAKhSSxWE wEJXYQr/M2SYgsBlWJciTrTvEU3o6I3Jr/w/pl2azjA2uA1MF8UzwiBqh2R77y44HgkR Flp1KsGiDi9XPR6sv65/TSY2rvFFOo6hH8vFtIGZIx2VyxskCsM3UOroTfEEfu2qceMq NYiA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1690770137; x=1691374937; h=in-reply-to:content-language:references:to:subject:user-agent :mime-version:date:message-id:from:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=5/IwxESKTp+4b5Uxm6W8imA/WVjsLKDeGwKgqhxnOBw=; b=gNCPQDC4dohAiZDFT1kVuLPzTCoqYKjxtISv37p+n56fS/ii4UEMhAXnPNn81jtkWo LMPtJwL/f7YDEKwDNXZ7NrYeaBYHO8iNIqr9QdvdcKHj/x7efoLTfyW4sqm62SyIBoz1 4OKCNbRi//Hecw0280fIxHtf2C5VaZ2tIDfsgKxgeM2t6RMO8rLgKzbeudkuGXMfihfk M/WbKTdE6w981vxtKKC48vVKJStWB91O8dhftOiFTmPpVqxKhWq8aRd4U8tM25frwzmX ZvakKtQyzEHUBqd88fz/po8OaHt9qB05QAbzqkiufDvZpvMuWatYT6Xfr/8+4Y1eAou3 UsKA== X-Gm-Message-State: ABy/qLaYlUjVyEHwltpRT2NVw8WI5QUhNnIDLW+yh53A8YKICOrxTV3F 7FLLehW1jqGoKkKvW6pqMm7McR+P6ySV7w== X-Google-Smtp-Source: APBJJlGAPQfeKJIRjNEguxaYfX3cRViP7e8jB0eBRUPEkfw/F/a7nRaSpy0+Q04d6FU4FgAEgEOY+A== X-Received: by 2002:ac8:5f8f:0:b0:403:b395:b450 with SMTP id j15-20020ac85f8f000000b00403b395b450mr13944343qta.2.1690770137078; Sun, 30 Jul 2023 19:22:17 -0700 (PDT) Received: from [192.168.2.170] ([67.70.150.114]) by smtp.gmail.com with ESMTPSA id s26-20020a05620a031a00b00765a676b75csm2908622qkm.21.2023.07.30.19.22.16 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Sun, 30 Jul 2023 19:22:16 -0700 (PDT) From: Amn Ojee Uw X-Google-Original-From: Amn Ojee Uw Content-Type: multipart/alternative; boundary="------------N9rhisMWr5DDQsBmXb1AGxIu" Message-ID: <931207bb-42f2-3d1a-7b89-c5f3aa1c5b1a@gmail.com> Date: Sun, 30 Jul 2023 22:22:07 -0400 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.13.0 Subject: Re: Upgrading To: pgsql-general@lists.postgresql.org References: <2426dfb5-63f7-a166-5780-5433da798a9e@gmail.com> <20230730153437.bkogcoh4jyyzwjdz@hjp.at> Content-Language: en-US In-Reply-To: <20230730153437.bkogcoh4jyyzwjdz@hjp.at> 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. --------------N9rhisMWr5DDQsBmXb1AGxIu Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit Thank you Ron and Peter for taking the time to respond to my call for help. In summery, I'd like to use PostgreSQL-15. However, since my Debian 12 already has already PostgreSQL-15 installed, did I inadvertently overwrote PostgreSQL-15 when I installed PostgreSQL-12? If so, how do I remove PostgreSQL-12 and continue on with PostgreSQL-15. Please note that I installed using the following command /*sudo apt-get -y install postgresql-12*/ Thanks in advance. On 7/30/23 11:34 a.m., Peter J. Holzer wrote: > On 2023-07-30 07:53:54 -0400, Amn Ojee Uw wrote: >> On my Debian 12, I installed PostgreSQL-12, > Where did you install that from? > > AFAICS, Debian 12 comes with PostgreSQL 15. > >> 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? > If you stay with the same source, Just installing the new version and > then invoking pg_upgrade (or a variant - PGDG, Debian, Ubuntu have > pg_upgradecluster) should do the trick. > > If you switch sources, the setup may be sufficiently different that > pg_dump/pg_restore may be the easiest way. > > hp > --------------N9rhisMWr5DDQsBmXb1AGxIu Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit

Thank you Ron and Peter for taking the time to respond to my call for help.

In summery, I'd like to use PostgreSQL-15.

However, since my Debian 12 already has already PostgreSQL-15 installed, did I inadvertently overwrote PostgreSQL-15 when I installed PostgreSQL-12? If so, how do I remove PostgreSQL-12 and continue on with PostgreSQL-15.

Please note that I installed using the following command

sudo apt-get -y install postgresql-12

Thanks in advance.


On 7/30/23 11:34 a.m., Peter J. Holzer wrote:
On 2023-07-30 07:53:54 -0400, Amn Ojee Uw wrote:
On my Debian 12, I installed PostgreSQL-12,
Where did you install that from?

AFAICS, Debian 12 comes with PostgreSQL 15.

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?
If you stay with the same source, Just installing the new version and
then invoking pg_upgrade (or a variant - PGDG, Debian, Ubuntu have
pg_upgradecluster) should do the trick.

If you switch sources, the setup may be sufficiently different that
pg_dump/pg_restore may be the easiest way.

        hp

--------------N9rhisMWr5DDQsBmXb1AGxIu--