Re: Issue installing postgis on RHEL9

; nobest' to > use not only best candidate packages) > > I have epel enabled and the only version of armadillo available is > 12.6.6-2.el9 > > Does anyone have any suggestions on how to resolve the issue? I haven't been maintaining PostGIS 3.0 RPMs for a while. Let

Re: Issue installing postgis on RHEL9

p uninstallable packages or '-- > nobest' to > use not only best candidate packages) Fixed in 3.0.9-2. Please make sure that you update repository cache first to receive the updates. Regards, -- Devrim Gündüz Open Source Solution Architect, PostgreSQL Major Contributor Twitter: @De

Re: Moving from Linux to Linux?

Hi, (Sorry for the top posting) Streaming replication won't work between SLES and RHEL, mostly because of glibc incompatibilities. Use logical replication. Regards, Devrim On 11 March 2025 16:22:26 GMT, Paul Foerster wrote: >Hi, > >we are considering changing the PostgreSQL platform from SUS

Re: Updated Fedora 40 and Fedora 41 RPM packages of Pgpool-II 4.5.5 in the repo

Hi, On Thu, 2024-12-05 at 07:16 +0100, Gerhard Wiesinger wrote: > Any chance to get Updated Fedora 40 and Fedora 41 RPM packages of > Pgpool-II 4.5.5 in the repo quickly? FWIW I updated the packages in PGDG repo a couple of weeks back. Regards, -- Devrim Gündüz Open Source Solution Arc

Re: libpq5 error

ion so that dnf will ignore that. Regards, -- Devrim Gündüz Open Source Solution Architect, PostgreSQL Major Contributor Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part

Re: 回复：searching for libpq5-14.1-42PGDG.rhel8.x86_64

s/8025#note-1 Regards, -- Devrim Gündüz Open Source Solution Architect, PostgreSQL Major Contributor Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part

Re: Yum Update nothing provides libarmadillo.so.12()(64bit) needed by gdal36-libs-3.6.4-6PGDG.rhel9.x86_64 from pgdg-common

at it is enabled. Also make sure that armadillo is not in the excludes list in either dnf.conf or in the repo config files. -HTH Regards, -- Devrim Gündüz Open Source Solution Architect, PostgreSQL Major Contributor Twitter: @DevrimGunduz , @DevrimGunduzTR

Re: Yum Update nothing provides libarmadillo.so.12()(64bit) needed by gdal36-libs-3.6.4-6PGDG.rhel9.x86_64 from pgdg-common

https://yum.postgresql.org/howto/ Regards, -- Devrim Gündüz Open Source Solution Architect, PostgreSQL Major Contributor Twitter: @DevrimGunduz , @DevrimGunduzTR

Re: multiple missing providers from pgdg-common

st armadillo 12 for RHEL 9, 8 and Fedora. Thanks for the report. Regards, -- Devrim Gündüz Open Source Solution Architect, PostgreSQL Major Contributor Twitter: @DevrimGunduz , @DevrimGunduzTR

Re: multiple missing providers from pgdg-common

What's that ? On 13 January 2024 20:26:19 CET, Joseph G wrote: >> >> Problem: package from @commandline requires postgis33_15, but none of >> the providers can be installed >> - package postgis33_15-3.3.1-1.rhel8.x86_64 from pgdg15 requires >> gdal35-libs >= 3.5.2, but none of the prov

Re: PostgreSQL 11 packages gone from reporpms?

pos today. Updated archive repo info in here as well: https://yum.postgresql.org/repopackages/#pgredhatoldrepos Regards, -- Devrim Gündüz Open Source Solution Architect, PostgreSQL Major Contributor Twitter: @DevrimGunduz , @DevrimGunduzTR

Re: RHEL repo package crc mismatches

945931900(sha25 > 6) > > It would be great if you could correct that too. This package does not exist on main side, I believe you may need to sync again. Regards, -- Devrim Gündüz Open Source Solution Architect, PostgreSQL Major Contributor Twitter: @DevrimGunduz , @DevrimGunduzTR

Re: RHEL repo package crc mismatches

the same packages. Please let me know if this solves your problem. Again, thanks for the report. Regards, -- Devrim Gündüz Open Source Solution Architect, PostgreSQL Major Contributor Twitter: @DevrimGunduz , @DevrimGunduzTR

Re: RHEL repo package crc mismatches

e report. This definitely does not look like a security issue, but need run further checks. I think it is an rsync issue. I'll reply again as soon as I'm done. Regards, -- Devrim Gündüz Open Source Solution Architect, PostgreSQL Major Contributor Twitter: @DevrimGunduz , @DevrimGunduzTR

Re: Install pg_dump and pg_restore on UBI8 and UBI8-minimal

's pg_dump and pg_restore will work against v12, so you may want to try these :-) Please let me know if you see any problems. Regards, -- Devrim Gündüz Open Source Solution Architect, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part

Re: plpython3 package installation problem

runtime libraries > shiboken-python36-libs.x86_64 : CPython bindings generator for C++ > libraries - > # yum list python36-libs.x86_64 > Installed Packages > python36-libs.x86_64 >  3.6.8-1.el7 > python3-libs is an alias for python36-libs. Please install that package first.

Re: [RPM/CentOS7] Need to disable repo_gpgcheck on pgdg-common when using RPM version 42.0-17.1

ttps://download.postgresql.org/pub/repos/yum/common/redhat/rhel-7-x86_64/repodata/repomd.xml > : > [Errno -1] repomd.xml signature could not be verified for pgdg-common > > I have not made any changes to /etc/yum.repos.d/pgdg-redhat-all.repo yum clean metadata yum install postgresql10

Re: [RPM/CentOS7] Need to disable repo_gpgcheck on pgdg-common when using RPM version 42.0-17.1

into the section pgdg-common. > > Hope it can help others, Actually please put that setting back. There was a sync issue which I fixed yesterday. repo_gpgcheck should be 1, per: https://people.planetpostgresql.org/devrim/index.php?/archives/113-CVE-2021-20271-and-PostgreSQL-YUMDNF-repo.html R

Re: yum update for postgresql rpms

#x27;t look to be necessary. > > I don't recall this automatic postmaster restart occurring a few > weeks ago when I went from 12.4.1 to 12.5.1 - perhaps it did, but I > just stopped/re-started postgres unnecessarily. That is the behaviour since 15 years :) Regards, -- Devrim Gün

Re: pg_upgrade from 12 to 13 failes with plpython2

st that I'm guessing 99% of the users don't read. Published a blog post today: https://people.planetpostgresql.org/devrim/index.php?/archives/106-What-is-new-in-PostgreSQL-13-RPMs.html Same text will go to yum.postgresql.org tomorrow. (Sorry for the delay) Regards, -- Devrim Gündü

Re: Changing the data directory path before the initial configuration of PostgreSQL 10.7.1

ql/data Then you can use setup script as usual. Another alternative is creating a copy of the unit file under /etc/systemd/system, changing $PGDATA inside that file and run the setup script. This should be documented on the top of the unit file. -HTH Regards, -- Devrim Gündüz Open Source

Re: FATAL: could not load library "/usr/pgsql-13/lib/libpqwalreceiver.so" during replication

Hi, On Sun, 2020-12-20 at 06:23 +0530, Rambabu V wrote: > [root@node2 ~]# cat /etc/redhat-release > Red Hat Enterprise Linux Server release 7.2 (Maipo) IIRC RHEL 7 RPMs support RHEL 7.6+. Please update. Regards, -- Devrim Gündüz Open Source Solution Architect, Red Hat Certified En

Re: pg_upgrade from 12 to 13 failes with plpython2

opped the extension, I guess. Regards, -- Devrim Gündüz Open Source Solution Architect, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part

Re: Postgresql13-devel fails to install on centos 7

is needed for -devel RPMs as well: https://yum.postgresql.org/news/devel-rpms-require-a-new-repository/ Regards, -- Devrim Gündüz Open Source Solution Architect, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part

Re: pg_upgrade from 12 to 13 failes with plpython2

FWIW, older PostgreSQL major versions still have PY 2 support. This is for PostgreSQL 13 only. [1] : https://www.postgresql.org/message-id/20200522080114.GA449430%40msg.df7cb.de Regards, -- Devrim Gündüz Open Source Solution Architect, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGundu

Re: pg_upgrade from 12 to 13 failes with plpython2

Right. Regards, -- Devrim Gündüz Open Source Solution Architect, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part

Re: pg_upgrade from 12 to 13 failes with plpython2

Hi, On Tue, 2020-11-17 at 12:18 -0800, Adrian Klaver wrote: > This was announced where and when? https://www.postgresql.org/message-id/333f3aa334ba93019c75fffaec373f2bf4275d28.camel%40gunduz.org Regards, -- Devrim Gündüz Open Source Solution Architect, Red Hat Certified Engineer Twit

Re: pg_upgrade from 12 to 13 failes with plpython2

file "$libdir/plpython2": No such file or directory I dropped PL/Python support along with PostgreSQL 13 RPMs. Regards, -- Devrim Gündüz Open Source Solution Architect, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part

Re: Issue upgrading from 9.5 to 13 with pg_upgrade: "connection to database failed: FATAL: database "template1" does not exist"

upgrade seems to be running now. (rpm packager speaking) Ouch. I partially fixed this problem (clean installations should not have this issue, as no other package requires PROJ, and we already have our own PROJ. Let me see what I can do to fix this completely. Regards, -- Devrim Gündüz Open Sou

Re: How to get debuginfo from building source code

g/pub/repos/yum/debug/10/redhat/rhel-7.4-x86_64/ 10.3 is 2,5 years old. I would update to 10.14 first. Regards, -- Devrim Gündüz Open Source Solution Architect, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part

Re: rum index supported on pg13?

Hi Teodor, On Wed, 2020-10-14 at 18:49 +0300, Teodor Sigaev wrote: > Thank you, fixed and published. Can you please release a new tarball? We need that to build the RPM packages. I'm still seeing 1.3.6 as the latest version. Thanks! Regards, -- Devrim Gündüz Open Source Solution A

Re: Yum repository RPM behind release

ll create the new file as pgdg-redhat-all.repo.rpnew (See the .rpmnew suffix). In that case, users are expected to merge the changes manually (or simply do what you did) Regards, -- Devrim Gündüz Open Source Solution Architect, Red Hat Certified Engineer Twitter: @DevrimGunduz , @Devri

Re: Dependency problem using community repo on Redhat 7

s. Any ideas? We are trying to > get the ruby gem installed. It works with the Redhat dist of > PostgreSQL but we prefer community. > Any help would be appreciated https://yum.postgresql.org/news/devel-rpms-require-a-new-repository/ Regards, -- Devrim Gündüz Open Source Solution Architec

Re: Yum repository RPM behind release

4/pgdg-redhat-repo-latest.noarch.rpm>) still points at rc1. > > I also noticed that I didn't get rc1 for a while after the release Please update the repo RPM to the *latest* version first (42.0-13 or above). rc packages were in the testing repo. v13 packages went to the stable re

Re: Dependency problem using community repo on Redhat 7

equire-a-new-repository/ Regards, -- Devrim Gündüz Open Source Solution Architect, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part

aarch64 support is available on yum.postgresql.org

redmine: https://redmine.postgresql.org/projects/pgrpms/issues/new (requires community username) Regards, -- Devrim Gündüz Open Source Solution Architect, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part

Announcing "common" YUM repository

the repo file as described above. * How can I get more support? Please send an email to pgsql-pkg-...@lists.postgresql.org , or submit an issue in the community issue tracker: https://redmine.postgresql.org/projects/pgrpms/issues Regards, -- Devrim Gündüz Maintainer, PostgreSQL RPM

Re: Cstore_fdw issue.

inks. Regards, -- Devrim Gündüz Open Source Solution Architect, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part

Re: Cstore_fdw issue.

Hi, On Thu, 2020-04-02 at 20:40 +, Moses Mafusire wrote: > Hi,I am new to PostgreSQL, successfully installed PGSql v12.2 on my CentOS 7 > machine and I am trying to install cstore_fdw. yum install cstore_fdw_12 Regards, -- Devrim Gündüz Open Source Solution Architect, Red Hat Cer

Re: pg12 rc1 on CentOS8 depend python2

Hi, On Fri, 2019-09-27 at 09:38 -0400, Tom Lane wrote: > Another idea might be to bundle them into the plpython package > instead of contrib (and similarly for the plperl transforms). This went into the last week's minor updates. Regards, -- Devrim Gündüz Open Source Solution Arc

Re: pg12 rc1 on CentOS8 depend python2

ckage do not depend on PythonX. Regards, -- Devrim Gündüz Open Source Solution Architect, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part

Re: pg12 rc1 on CentOS8 depend python2

Am I missing something? Regards, -- Devrim Gündüz Open Source Solution Architect, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part

Re: How to install Postgres 12 beta with YUM

Hi, v12 is in testing repos only. Find [pgdg12-updates-testing] in the repo file, and enable that one, please. Regards, Devrim On 22 August 2019 21:29:44 GMT+03:00, "Igal @ Lucee.org" wrote: >I have installed the CentOS 7 PGDG file from >https://yum.postgresql.org/repopackages.php > >If I `c

Re: Missing RHEL rpm(pg_catcheck-11) in postgres 11 repo.

.5-x86_64/. > > We request your help in getting this rpm to the repo. Pushed packages yesterday. Sorry for the inconvenience. Regards, -- Devrim Gündüz EnterpriseDB: https://www.enterprisedb.com PostgreSQL Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR

Re: Who and How is responsible for released installations packages and 3rd party packs? (e.g. on https://yum.postgresql.org/9.6/redhat/rhel-7.3-x86_64/)

Hi, On Fri, 2018-08-10 at 21:49 +0200, Christoph Berg wrote: > plv8 will work for anyone willing to go through that. It's just not > feasible to support it from a packager perspective. +1 from me. Regards, -- Devrim Gündüz EnterpriseDB: https://www.enterprisedb.com PostgreSQL Cons

Re: Who and How is responsible for released installations packages and 3rd party packs? (e.g. on https://yum.postgresql.org/9.6/redhat/rhel-7.3-x86_64/)

all packages themselves > (RPMs, debs, etc) There are community RPMs, and then the RPMs supplied by Red Hat / CentOS via OS or SCL. Community packages has wider range of supported PostgreSQL versions, and wider range of packages. Regards, -- Devrim Gündüz EnterpriseDB: https://www.e

Re: Who and How is responsible for released installations packages and 3rd party packs? (e.g. on https://yum.postgresql.org/9.6/redhat/rhel-7.3-x86_64/)

Hi, On Thu, 2018-08-02 at 08:53 +0300, Alexandru Lazarev wrote: > I saw on URL there are PG 9.6.8 and 9.6.9 - Are there maintained only > latest 2 build releases? Yes, older releases are deleted automagically. Regards, -- Devrim Gündüz EnterpriseDB: https://www.enterprisedb.com Post

Re: Who and How is responsible for released installations packages and 3rd party packs? (e.g. on https://yum.postgresql.org/9.6/redhat/rhel-7.3-x86_64/)

build point of view. RPMs are not supposed to download extra dependencies from elsewhere. Regards, -- Devrim Gündüz EnterpriseDB: https://www.enterprisedb.com PostgreSQL Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally

Re: Failed rpm package signature checks with reposync

re > check. > Removing osm2pgrouting_10-debuginfo-2.3.3-1.rhel7.x86_64.rpm due to failed > signature check. Ok, verified on my end as well. Fixed this, and pushed them to the repo. They will be available 1 hour later. Can you please try again then? Regards, -- Devrim Gündüz EnterpriseD

Re: Failed rpm package signature checks with reposync

l.org/pub/repos/yum/10/redhat/rhel-7-x86_64 > enabled=0 > gpgcheck=1 > gpgkey=https://download.postgresql.org/pub/repos/yum/RPM-GPG-KEY-PGDG-10 > > > Any reasons for this? > > Thanks > Bruno Lavoie -- Devrim Gündüz EnterpriseDB: https://www.enterprisedb.com PostgreSQL Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part

Re: pgaudit?

udit 1.2 for PostgreSQL 10) 2 weeks ago. Regards, -- Devrim Gündüz EnterpriseDB: https://www.enterprisedb.com PostgreSQL Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description: This is a digitally signed message part

Re: Missing RHEL rpm(pg_catcheck-10) in postgres 10 repo.

86_64/ > We request your help in getting this rpm to the repo. Pushed 1.1.0 to repos, which was released about an hour ago. 1.1.0 includes support for v10. Thanks for the heads-up. Regards, -- Devrim Gündüz EnterpriseDB: https://www.enterprisedb.com PostgreSQL Consultant, Red Hat Cert

Re: Unsigned RPM's ?

gt; gresql93-server-9.3.20-3PGDG.rhel7.x86_64.rpm > " This was also raised here: https://redmine.postgresql.org/issues/2942 ...and I fixed it today. Sorry for the inconvenience. Regards, -- Devrim Gündüz EnterpriseDB: https://www.enterprisedb.com PostgreSQL Consultant, Red Hat Certifi

Re: Missing RHEL rpm(pg_catcheck-10) in postgres 10 repo.

/rhel-6.7-x86_64/ > We request your help in getting this rpm to the repo. Latest pg_catcheck stable release is not compatible with v10. I raised this internally with EnterpriseDB, and I'll reply you as soon as I hear from our developers. Regards, -- Devrim Gündüz EnterpriseDB: https://w