Re: Obsolete Linux downloads (Debian) instructions

2024-04-16 Thread Christoph Berg
Re: Daniel Gustafsson > > On 12 Apr 2024, at 12:43, Laura Smith > > wrote: > > > Who do I have to badger to get the obsolete and frankly dangerous Debian > > repo instructions fixed @ https://www.postgresql.org/download/linux/debian/ > > ? I still think that "frankly dangerous" is a gross

Re: AIX and EAGAIN on open()

2022-07-04 Thread Christoph Berg
Re: Thomas Munro > > Does anything of that ring a bell for someone? Is that an AIX bug, a > > PG bug, or something else? > > No clue here. Anything unusual about the file system (NFS etc)? Can > you truss/strace the system calls, to sanity check the flags arriving > into open(), and see if

AIX and EAGAIN on open()

2022-06-20 Thread Christoph Berg
Hello, a customer running PG on AIX [1] is occasionally seeing "Resource temporarily unavailable" (EAGAIN) returned by open() calls: [1] We have PostgreSQL 11.13 on powerpc-ibm-aix7.2.5.0, compiled by /opt/IBM/xlc/13.1.0/bin/xlc, 64-bit 2022-05-19 03:28:13 CEST:127.0.0.1(63265):x@x:[64029168]:

PostgreSQL on focal and llvm version

2022-04-01 Thread Christoph Berg
Re: hubert depesz lubaczewski > Soo... plot thickens. > > Looks that pg 12 supplied by pgdg required libllvm9: > > =$ apt-cache show postgresql-12 | grep -E '^(Package|Version|Depends):' > Package: postgresql-12 > Version: 12.9-2.pgdg20.04+1 > Depends: ..., libllvm9 (>= 1:9~svn298832-1~), ... >

Re: Inherited an 18TB DB & need to backup

2020-05-15 Thread Christoph Berg
Re: Rory Campbell-Lange > On 15/05/20, Suhail Bamzena (suhailsa...@gmail.com) wrote: > > Hello All, > > I have very recently inherited an 18 TB DB that is running version 9.2. Push hard to get that upgraded to a supported version. Christoph

Re: pg12 rc1 on CentOS8 depend python2

2019-10-01 Thread Christoph Berg
Re: Devrim Gündüz 2019-09-30 <21705bb57210f01b559ec2f5de8550df586324e2.ca...@gunduz.org> > I think postgresql-contrib-py3 is really the best idea at this point, > otherwise > I cannot see a clean way to make this without breaking existing installations. Users of these (now contrib) modules need

Re: pg12 rc1 on CentOS8 depend python2

2019-09-27 Thread Christoph Berg
Re: Tom Lane 2019-09-27 <19495.1569591...@sss.pgh.pa.us> > Another idea might be to bundle them into the plpython package > instead of contrib (and similarly for the plperl transforms). Fwiw, the Debian packages do that. Christoph

Re: Upgrading old server

2019-09-25 Thread Christoph Berg
Re: Ekaterina Amez 2019-09-25 <8818b028-bd2d-412e-d4e3-e29c49ffe...@zunibal.com> > We've decided to upgrade our PostgreSQL production servers. First task is > remove an old v7.14 version. It was supposed to be upgraded to a v8.4 > server. The server was installed, several databases where released

Re: Forks of pgadmin3?

2019-03-26 Thread Christoph Berg
Re: Jeff Janes 2019-03-23 > On Fri, Mar 22, 2019 at 8:04 AM Steve Atkins wrote: > > > On Mar 22, 2019, at 10:56 AM, Christian Henz > > There's the BigSQL fork, which had at least some minimal support > > for 10. I've no idea whether it's had / needs anything for 11 > > I just installed

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/)

2018-08-10 Thread Christoph Berg
Re: Bruce Momjian 2018-08-10 <20180810194407.ge7...@momjian.us> > Wow, OK. That's bad news. So PL/v8 is no longer a viable stored > procedure language? It is bad news, the plv8 upstream is very pleasant to work with. But now building plv8 means building v8 first, which means something like

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/)

2018-08-10 Thread Christoph Berg
Re: Bruce Momjian 2018-08-10 <20180810192205.gc7...@momjian.us> > Uh, who is building PL/v8 currently, and for what operating systems? No one? No one is likely correct. Christoph

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/)

2018-08-03 Thread Christoph Berg
Re: Devrim Gündüz 2018-08-03 <1cdedaf455c4f326f31b103ab805d48da9914cb7.ca...@gunduz.org> > > What about 3rd party libraries like plv8 - Who and How (based on which > > criteria, which versions) build RPM and upload them there? > > Latest versions of PL/v8 does not build on RHEL/Fedora anymore,

Re: postgresql-10.3 on unbuntu-17.10 - how??

2018-03-23 Thread Christoph Berg
Re: Stuart McGraw 2018-03-23 > So what I was thinking of was rebuilding the Pgdg Ubuntu source > package (I'm assuming one is available somewhere). I have had > good results on Fedora backporting current versions of Postgresql > from later

Re: postgresql-10.3 on unbuntu-17.10 - how??

2018-03-20 Thread Christoph Berg
Re: Adrian Klaver 2018-03-20 <4c40e7c5-efa7-00d7-b891-acc9c1ec7...@aklaver.com> > > However I need to upgrade to 10.3 and the normal "apt update; > > apt upgrade" does not offer 10.3.  Also, doing a fresh install > > still installs 10.1. > > https://wiki.postgresql.org/wiki/Apt > "2018-01-17:

Re: Building PostgreSQL old version from source to test vulnerability CVE-2017-7546

2018-02-22 Thread Christoph Berg
Re: Julián Jiménez González 2018-02-21

Re: What generates pg_config.h?

2018-01-06 Thread Christoph Berg
Re: Adrian Klaver 2018-01-06 <67591f85-a910-2e0b-1fdd-9c774eacd...@aklaver.com> > The problem you are running into is that the build process is using both the > older(9.6.5) and newer(10.0) pg_config.h at the same time. Fwiw, all issues I've seen so far of that kind could be resolved by putting