Re: Proposal: Early providing of PGDG repositories for the major Linux distributions like Fedora or Debian

the beta phase of the distributions: This is what I do for the Fedora releases. I'm sure you've noticed that in the past. Regards, -- Devrim Gündüz Open Source Solution Architect, PostgreSQL Major Contributor Twitter: @DevrimGunduz , @DevrimGunduzTR

Re: HEAD build error on Fedora 39

(like this) were missing. Regards, -- Devrim Gündüz Open Source Solution Architect, PostgreSQL Major Contributor Twitter: @DevrimGunduz , @DevrimGunduzTR

Weird "null" errors during DROP TYPE (pg_upgrade)

We noticed that this data type was actually not used, so decided to drop it: === DROP TYPE "foobar"."_packagestoptemp"; ERROR: cannot drop (null) because (null) requires it HINT: You can dro

HEAD build error on Fedora 39

' failed to parse ^ make[3]: *** [Makefile:72: postgres-full.xml] Error 1 Any hints? Regards -- Devrim Gündüz Open Source Solution Architect, PostgreSQL Major Contributor Twitter: @DevrimGunduz , @DevrimGunduzTR

Re: Security lessons from liblzma

her major releases. Please note that both Debian folks and me build about 300 other packages to support the ecosystem. Just saying. Regards, -- Devrim Gündüz Open Source Solution Architect, PostgreSQL Major Contributor Twitter: @DevrimGunduz , @DevrimGunduzTR

Re: Security lessons from liblzma

reSQL git repo. OTOH, we also carry non-patches like README files, systemd unit files, pam files, setup script, etc., which are very RPM specific. Regards, -- Devrim Gündüz Open Source Solution Architect, PostgreSQL Major Contributor Twitter: @DevrimGunduz , @DevrimGunduzTR

Re: Guiding principle for dropping LLVM versions?

is great for HEAD. Regards, -- Devrim Gündüz Open Source Solution Architect, PostgreSQL Major Contributor Twitter: @DevrimGunduz , @DevrimGunduzTR

d844cd75a and postgres_fdw

message-id/1852635.1682808624%40sss.pgh.pa.us OTOH, same query works (against the FDW) when we remove the following WHERE clause: WHERE tbl.table_status = 'A' AND tbl.table_id <> 1 AND tbl.table_id <> - 2 Any hints? Regards, -- Devrim Gündüz Open Source Solution Architect, Postgr

Re: LLVM 16 (opaque pointers)

hat RPMs built fine on Fedora 39 with those patches, which ships LLVM 17.0.2 as of today. I can also confirm that builds are not broken on RHEL 9 and 8 and Fedora 37 which ship LLVM 15, and Fedora 38 (LLVM 16). Thanks again! Regards, -- Devrim Gündüz Open Source Solution Architect, PostgreSQ

Re: Guiding principle for dropping LLVM versions?

hey don't provide older Clang packages, which means we have to link to the latest release anyway (like currently Fedora 38 packages are waiting for LLVM 16 patch, as they cannot be linked against LLVM 15) Regards, Regards, -- Devrim Gündüz Open Source Solution Architect, PostgreSQL Major Contributor Twitter: @DevrimGunduz , @DevrimGunduzTR

Re: LLVM 16 (opaque pointers)

ir new minor releases every 6 month, and we have to build older versions with new LLVM each time. >From RHEL point of view, it would be great if we can back-patch back to v12 :( Regards, -- Devrim Gündüz Open Source Solution Architect, PostgreSQL Major Contributor Twitter: @DevrimGunduz , @DevrimGunduzTR

PostgreSQL 17 alpha RPMs

ards, -- Devrim Gündüz Open Source Solution Architect, PostgreSQL Major Contributor Twitter: @DevrimGunduz , @DevrimGunduzTR

Re: drop postmaster symlink

ed to create the symlink in the RPMs to make users' lives (and my life) easier. So, no objection from here. Regards, -- Devrim Gündüz Open Source Solution Architect, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR

Re: drop postmaster symlink

users may be unhappy about that, too. They also call postmaster directly. Regsards, -- Devrim Gündüz Open Source Solution Architect, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR

Re: drop postmaster symlink

/bin/postmaster -D ${PGDATA} ...and it helps us to find the "main" process a bit easily. 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: [PATCH] Fix build with LLVM 15 or above

Hi, On Tue, 2022-10-18 at 22:06 +1300, Thomas Munro wrote: > Will do first thing tomorrow. Just wanted to confirm that I pushed Fedora RPMs built against LLVM 15 by adding these patches. Thanks Thomas. Regards, -- Devrim Gündüz Open Source Solution Architect, Red Hat Certified Engin

Re: [PATCH] Fix build with LLVM 15 or above

o back-patch that eventually, but first things > first...). Fedora 37 is out very very soon, and ships with CLANG/LLVM 15. What is the timeline for backpatching llvm15 support? Thanks! Cheers, -- Devrim Gündüz Open Source Solution Architect, Red Hat Certified Engineer Twitter: @DevrimGunduz ,

Re: latest patches not updated in repos

our browser cache, perhaps? Actually I just pushed them. Only 13.8 updates were missing, sorry about that. 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: head fails to build on SLES 12

Hi, On Thu, 2022-03-31 at 10:26 -0400, Tom Lane wrote: > Devrim =?ISO-8859-1?Q?G=FCnd=FCz?= writes: > > Latest snapshot tarball fails to build on SLES 12.5, which uses GCC > > 4.8-8. Build log is attached. > > Hmm, what version of libzstd is present? 1.3.3 Regards, -

head fails to build on SLES 12

Hi, Latest snapshot tarball fails to build on SLES 12.5, which uses GCC 4.8-8. Build log is attached. Please let me know if you want me to provide more info. Thanks! Regards, -- Devrim Gündüz Open Source Solution Architect, PostgreSQL guy Twitter: @DevrimGunduz , @DevrimGunduzTR /usr/bin

Re: Postgres perl module namespace

Hi, On Thu, 2021-05-20 at 15:47 -0400, Andrew Dunstan wrote: > Meanwhile I would suggest that RPM maintainers exclude both requires > and provides for these five names. Done, thanks. Will appear in next beta build. Regards, -- Devrim Gündüz Open Source Solution Architect, Red Hat Cer

Re: Packaging - Packages names consistency (RPM)

Hi, RPM packager speaking: I agree that this is very annoying, and this is also in my todo list. Let me try to prioritize it. Regards, Devrim On 15 October 2020 17:23:33 GMT+03:00, Bruno Lavoie wrote: >Hi Hackers, > >First, thanks for working on such a great database! :) > >We're currently

Re: Binaries on s390x arch

RPMs: VMs: 2 OS: RHEL 7 and RHEL 8 vCPUs: 8 (each) Memory: 16 GB (each) Storage: 100GB 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

CUBE_MAX_DIM

, and never had a problem. I never added such patches to the RPMS, and will not -- but wanted to ask if we can safely increase it in upstream? Regards, -- Devrim Gündüz Open Source Solution Architect, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Description

Re: v13 latest snapshot build error

e version of the > patch that's in the Fedora repo. Exactly.Looks like I broke the patch while trying to update the patch. Sorry for the noise. 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: v13 latest snapshot build error

ild) Bad exit status from /var/tmp/rpm-tmp.PXbYKE (%build) IDK what is going on, but apparently something is broken somewhere. Cheers, -- Devrim Gündüz Open Source Solution Architect, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Descript

v13 latest snapshot build error

guc.o] Error 1 make[3]: *** [../../../src/backend/common.mk:39: misc-recursive] Error 2 make[3]: *** Waiting for unfinished jobs make[2]: *** [common.mk:39: utils-recursive] Error 2 make[1]: *** [Makefile:42: all-backend-recurse] Error 2 make: *** [GNUmakefile:11: all-src-recurse] Error 2

Re: v12 pg_basebackup fails against older servers (take two)

postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=beeb8e2e0717065296dc7b32daba2d66f0f931dd had a similar approach in backwards compatibility, so I also agree on fixing whatever breaks it. Regards, -- Devrim Gündüz Open Source Solution Architect, Red Hat Certified Engineer Twitter: @Devrim

pg_basebackup against older server versions

Hi, Apologies if this has been discussed before: When I run pg_basebackup in git head against v11 server, it treats v11 as v12: Does not create recovery.conf, adds recovery parameters to postgresql.auto.conf, and also creates standby.signal file. Is this expected, or a bug? Regards, -- Devrim

9.6.10 build warning on Fedora 28

__va_arg_pack ()); = 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: PostgreSQL: PY3 files in PY2 installation

Hi, On Mon, 2018-05-21 at 12:42 +0100, Devrim Gündüz wrote: > The following files are installed even when I build PostgreSQL 9.5+ on RHEL 7 > - > Python 2.7: > > hstore_plpython3u--1.0.sql > hstore_plpython3u.control > jsonb_plpython3u--1.0.sql > jsonb_plpython3u.control

PostgreSQL: PY3 files in PY2 installation

Hi, The following files are installed even when I build PostgreSQL 9.5+ on RHEL 7 - Python 2.7: hstore_plpython3u--1.0.sql hstore_plpython3u.control jsonb_plpython3u--1.0.sql jsonb_plpython3u.control ltree_plpython3u--1.0.sql ltree_plpython3u.control Is this expected? Regards, -- Devrim

GCC 8 warnings

/temp/pg-gcc8-v11.txt ...and this is from 9.6: https://gunduz.org/temp/pg-gcc8-9.6.txt 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: submake-errcodes

Hi, On Mon, 2018-04-16 at 09:24 +0200, Christoph Berg wrote: > Fwiw, setting MAKELEVEL=0 worked. Thanks! Great, it solved my problem as well! Thanks Tom. Regards, -- Devrim Gündüz EnterpriseDB: https://www.enterprisedb.com PostgreSQL Consultant, Red Hat Certified Engineer Twit

Re: submake-errcodes

apshot at: https://download.postgresql.org/pub/snapshot/dev/ When you rebuild it, you'll see the error. Regards, -- Devrim Gündüz EnterpriseDB: https://www.enterprisedb.com PostgreSQL Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature.asc Descr

Re: submake-errcodes

uce on F-27 box. > Which gmake version is this? 4.2.1 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: submake-errcodes

/errcodes.h" ^~ compilation terminated. make[1]: *** [: plpy_cursorobject.o] Error 1 === Regards, -- Devrim Gündüz EnterpriseDB: https://www.enterprisedb.com PostgreSQL Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR signature

Re: submake-errcodes

plpy_procedure.o] Error 1 make[1]: *** Waiting for unfinished jobs make[1]: *** [: plpy_cursorobject.o] Error 1 ========== Regards, -- Devrim Gündüz EnterpriseDB: https://www.enterprisedb.com PostgreSQL Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz

submake-errcodes

Hi, I used to run " cd src/backend make submake-errcodes " in the RPM spec file, but looks like it was removed recently. Is that replaced with something else, or removed completely? Regards, -- Devrim Gündüz EnterpriseDB: https://www.enterprisedb.com PostgreSQL Consultant, Red Hat

Re: How to Works with Centos

e also "supported" by them. As mentioned in this thread, the community RPMs are also a (better) option, because you can install multiple versions at the same time. Regards, -- Devrim Gündüz EnterpriseDB: https://www.enterprisedb.com PostgreSQL Consultant, Red Hat Certified Engineer Twitte

Re: pspg - psql pager

lly creates tickets to ping me, so we are usually up-to-date. The updated packages will appear in the repos around 30 mins later. Regards, -- Devrim Gündüz EnterpriseDB: https://www.enterprisedb.com PostgreSQL Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGundu