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 1qRDIe-000vFE-2I for pgsql-general@arkaria.postgresql.org; Wed, 02 Aug 2023 14:58:08 +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 1qRDIc-005iNM-6z for pgsql-general@arkaria.postgresql.org; Wed, 02 Aug 2023 14:58:06 +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 1qRDIb-005iNC-T4 for pgsql-general@lists.postgresql.org; Wed, 02 Aug 2023 14:58:06 +0000 Received: from smtp.burggraben.net ([88.198.69.140]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qRDIY-000A1t-PJ for pgsql-general@postgresql.org; Wed, 02 Aug 2023 14:58:05 +0000 Received: from squirrel.exwg.net (p57a63b7c.dip0.t-ipconnect.de [87.166.59.124]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client CN "squirrel.exwg.net", Issuer "R3" (not verified)) by smtp.burggraben.net (Postfix) with ESMTPS id CE237C011E0; Wed, 2 Aug 2023 16:58:00 +0200 (CEST) Received: by squirrel.exwg.net (Postfix, from userid 1000) id AB58E1D8AF; Wed, 2 Aug 2023 16:57:59 +0200 (CEST) Date: Wed, 2 Aug 2023 16:57:59 +0200 From: Christoph Moench-Tegeder To: marco.ptz@tiscali.it Cc: pgsql-general@postgresql.org Subject: Re: Different releases in the same server Message-ID: References: <7229c9037c2b263c23b4a9d48d7732a2@tiscali.it> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline In-Reply-To: <7229c9037c2b263c23b4a9d48d7732a2@tiscali.it> User-Agent: Mutt/2.0.5 (2021-01-21) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ## marco.ptz@tiscali.it (marco.ptz@tiscali.it): > we have recently started to manage a production server > running a 9.6 postgres. Which is EOL for nearly two years now: https://www.postgresql.org/support/versioning/ > We > have to upgrade to postgres 12.x Which is going EOL in little over one year's time. You should look into https://yum.postgresql.org/packages/ where you can get packages with some real production life time. > At present in /usr/bin there are not links as > aspected for use with alternatives, but there are files belonging to > 9.2 > version except for pg_basebackup: That sounds severly broken, as if you installed CentOS original "postgresql" package (CentOS 7 ships with the really ancient 9.2). Check rpm and yum where that came from and then it's time for some cleanup. In the mean time, make sure to always call all PostgreSQL utilities with full path. > Could > we have trouble having 9.6 and 12 running in the same time (we will > upgrade with pg_upgrade) in such server? For pg_upgrade, you will need both the old and new binaries installed. > HOW can we to fix the presence > of release 9.2 files in /usr/bin? Maybe best use the upgrade opportunity to move everything to a clean installation on a new VM? > Will the simbolic links in /usr/bin be > created by alternatives once the 9.2 release will be > dropped/deinstalled/deleted? The symlinks would be created by registering the repective versions with the alternatives system - usually that happens in the post-install scripts of the RPMs. You could do that manually (after removing 9.2) or maybe by re-installing your current (ancient) packages. Cleanest solution would be a new server - who knows what other surprises are hidden on that machine? Regards, Christoph -- Spare Space.