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 1pMpIP-0001Oo-4c for pgsql-general@arkaria.postgresql.org; Tue, 31 Jan 2023 11:59:29 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pMpIM-0003xL-Nc for pgsql-general@arkaria.postgresql.org; Tue, 31 Jan 2023 11:59:26 +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 1pMpIM-0003xC-9Z for pgsql-general@lists.postgresql.org; Tue, 31 Jan 2023 11:59:26 +0000 Received: from mail-pj1-x102c.google.com ([2607:f8b0:4864:20::102c]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pMpIF-0006NB-GT for pgsql-general@lists.postgresql.org; Tue, 31 Jan 2023 11:59:25 +0000 Received: by mail-pj1-x102c.google.com with SMTP id m11so14027185pji.0 for ; Tue, 31 Jan 2023 03:59:19 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=in-reply-to:disposition-notification-to:from:references:to :content-language:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=bQqj9jo/2H8xih30GcXnVv8+Tioh/6leVcms70/ORgE=; b=PfNnsl/BzU1xnFeythoc9vw5s4+EucBc9Ps70BmJ9Q1ejzK4hNCdJASa8RmUt8upl+ UE9AFzjJtWUGSEDZMfZyqTLJIQiwTd1ayhvnAklB2eS+LgjRJOYpJnGBAt4Ndu1YkDB8 8jQEDtmTFfvLjYMlSYERSlaHOMaytZuTSUpDXe0/gf5m1AolUJ1PHtSlFWYmVFwBVRaY +B4LsJ/ZgLEvFn44hstQPUSaDcIE6GtocaXHd2GShw+k/Ul5Hi5Chgiwdh9F4wdIErIY iuSufCLEq43rr1sQRhwOBUEQh5sGKJCYABSsE0EJa9sDrcckQt0vpEs76dO5q/peCkAu cyig== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=in-reply-to:disposition-notification-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=bQqj9jo/2H8xih30GcXnVv8+Tioh/6leVcms70/ORgE=; b=IzavoJoPu72Z45B+gazdaXW3+pX4eK9jSK7DxJtSUyyogvv78quQ2Vx6GsZWrs3phD 2EvczOOAdSPXo6xlVq4zZypUTMv99BfonOZ26TV8BkOOgwOo6nHTd7D4foirLY5MlKgJ OvP9tY2UBA9FbfhijOoSslm7V80GYrGqBWW+TNh4mDwjFFLEhkVpwvvYJ8NpFpI4Jw1h mXV1Fjt8TddLwLThnTF6ok8dq2apoD8cM3omrWREgfpHo2nJhte3fjfaOLrHyHmVzLVg 3Z/GRWyAZn12K9xapD4siTkci7BTaWI8iRB8HlI7RNTeL6TReWcx+v/2b5nBJBVcCoff 8DmQ== X-Gm-Message-State: AO0yUKW35amMTLma9lTUBh9mFHUt2bfecQqj+p2EssfdJerkXfjDSoZ3 Y2E2w+Ljqcq78PZruUKIduPmU9PslFg= X-Google-Smtp-Source: AK7set8vTQEpp9NS8w4f0QQL9JU7lqJvR6BSBArLJIZRAD6iDWqt7T60XAUl4Rbmr//Zy3jYEzcJoA== X-Received: by 2002:a17:903:2291:b0:196:704e:2c9c with SMTP id b17-20020a170903229100b00196704e2c9cmr14311855plh.23.1675166356802; Tue, 31 Jan 2023 03:59:16 -0800 (PST) Received: from [192.168.0.7] ([139.228.184.155]) by smtp.gmail.com with ESMTPSA id i9-20020a1709026ac900b001967afdbc7bsm4691670plt.136.2023.01.31.03.59.15 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Tue, 31 Jan 2023 03:59:16 -0800 (PST) Content-Type: multipart/alternative; boundary="------------RfF97JdtimODBJnlT5DfQU3w" Message-ID: <51df9558-c982-2a72-0cab-ab36838a8626@gmail.com> Date: Tue, 31 Jan 2023 18:59:13 +0700 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:102.0) Gecko/20100101 Thunderbird/102.6.1 Subject: Re: Best Open Source OS for Postgresql Content-Language: en-US To: pgsql-general@lists.postgresql.org References: From: Surya Widyanto Disposition-Notification-To: Surya Widyanto In-Reply-To: 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. --------------RfF97JdtimODBJnlT5DfQU3w Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit Hi, From 2019, I've been using AlmaLinux from version 8.4 up to now version 8.7. This January, I've been trying to upgrade PostgreSQL from v14.6 to v15.1. When I install PostgreSQL v14.6 along side with v15.1 in the same server, it run without trouble at all, but because I'm using the PostGIS extension, there is one package *ogr_fdw_14 *than cannot be along side with the *ogr_fdw_15 *version, specifically on this file: Error: Transaction test error: file /usr/lib/.build-id/a0/a43182caa55ed9d3562e2d9b74a1dda150e2c4 from install of ogr_fdw_15-1.1.3-1.rhel8.x86_64 conflicts with file from package ogr_fdw_14-1.1.3-1.rhel8.x86_64 because of this problem, I'm currently stuck on upgrading the PostgreSQL to v15.1. Last week, on my development server I can install the *ogr_fdw_15 *on by using manual extraction of the RPM package to each individual directory with exception the conflicted file, and the extension is successfully installed and detected on the PostgreSQL v15.1.  Next weekend, I planned on upgrading the production server to v15.1 using the same method, unless anyone here can show me other method than manually extracting the RPM package. May be someone here on this mailing-list have access to the package manager that build the *ogr_fdw_14 *and *ogr_fdw_15* package, and release the package update to resolve the conflicted file, I'll be waiting for the package release update before I rollout the update to my production server. Best Regards, Surya Widyanto On 31-01-2023 15:02, Giovanni Biscontini wrote: > Hello everyone, >  we're looking for a Open Source alternative to Rhel for our VM server > dedicated to Postgresql (14->15) installations. We're testing Alma, > Rocky, and Oracle distributions as they're compatible with Rhel > package systems. > Can you share your experience on a similar choice? > Thanks in advance and best regards, Giovanni > > -- > > *Cordiali Saluti - Best Regards* > > > ***Dott. Giovanni Biscontini* > > * [Divisone Software]* > > **WEB: https://www.es2000.it > > ____________________________________ > > Privacy e riservatezza: il presente messaggio, così come i relativi > allegati, contengono dati ed informazioni da considerarsi strettamente > riservate ed è indirizzato esclusivamente al destinatario sopra > indicato, il quale è l'unico autorizzato a trattarlo in osservanza > delle norme del Regolamento UE 2016/679 (RGPD) . Preghiamo chiunque > ricevesse questo messaggio per errore di evitare di copiarlo, > divulgarlo, distribuirlo a terzi e di dare notizia al mittente > dell’errato invio, distruggendone poi l'eventuale copia cartacea e la > copia in formato elettronico. > > Il titolare dei dati potrà esercitare tutti i diritti di cui all'art.7 > del suddetto decreto tra cui quelli di accesso, rettifica, > aggiornamento, opposizione al trattamento e cancellazione > > *Please, print this e-mail only if necessary* > --------------RfF97JdtimODBJnlT5DfQU3w Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit
Hi,

From 2019, I've been using AlmaLinux from version 8.4 up to now version 8.7. This January, I've been trying to upgrade PostgreSQL from v14.6 to v15.1.
When I install PostgreSQL v14.6 along side with v15.1 in the same server, it run without trouble at all, but because I'm using the PostGIS extension, there is one package ogr_fdw_14 than cannot be along side with the ogr_fdw_15 version, specifically on this file:
Error: Transaction test error:

file /usr/lib/.build-id/a0/a43182caa55ed9d3562e2d9b74a1dda150e2c4 from 
install of ogr_fdw_15-1.1.3-1.rhel8.x86_64 conflicts with file from 
package ogr_fdw_14-1.1.3-1.rhel8.x86_64
because of this problem, I'm currently stuck on upgrading the PostgreSQL to v15.1. Last week, on my development server I can install the ogr_fdw_15 on by using manual extraction of the RPM package to each individual directory with exception the conflicted file, and the extension is successfully installed and detected on the PostgreSQL v15.1.  Next weekend, I planned on upgrading the production server to v15.1 using the same method, unless anyone here can show me other method than manually extracting the RPM package.

May be someone here on this mailing-list have access to the package manager that build the ogr_fdw_14 and ogr_fdw_15 package, and release the package update to resolve the conflicted file, I'll be waiting for the package release update before I rollout the update to my production server.

Best Regards,
Surya Widyanto


On 31-01-2023 15:02, Giovanni Biscontini wrote:
Hello everyone,
 we're looking for a Open Source alternative to Rhel for our VM server dedicated to Postgresql (14->15) installations. We're testing Alma, Rocky, and Oracle distributions as they're compatible with Rhel package systems. 
Can you share your experience on a similar choice? 
Thanks in advance and best regards, Giovanni 

--

 

 

Cordiali Saluti - Best Regards

 


 

 Dott. Giovanni Biscontini

 [Divisone Software]

 

  WEB: https://www.es2000.it

 

 

 

____________________________________

Privacy e riservatezza: il presente messaggio, così come i relativi allegati, contengono dati ed informazioni da considerarsi strettamente riservate ed è indirizzato esclusivamente al destinatario sopra indicato, il quale è l'unico autorizzato a trattarlo in osservanza delle norme del Regolamento UE 2016/679 (RGPD) . Preghiamo chiunque ricevesse questo messaggio per errore di evitare di copiarlo, divulgarlo, distribuirlo a terzi e di dare notizia al mittente dell’errato invio, distruggendone poi l'eventuale copia cartacea e la copia in formato elettronico.

Il titolare dei dati potrà esercitare tutti i diritti di cui all'art.7 del suddetto decreto tra cui quelli di accesso, rettifica, aggiornamento, opposizione al trattamento e cancellazione

Please, print this e-mail only if necessary


--------------RfF97JdtimODBJnlT5DfQU3w--