Re: Durgamahesh Manne
> with pg_partman By default proc() does not detach tables concurrently. How
> do we implement tables detach concurrently without blocking other sessions
> Here queries not using date column to detach tables with
> run_maintenance_proc() which is not using concurrently based
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 exa
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 there
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]:
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: 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: 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: 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: 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 h
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 BigSQL'
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 down
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: 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, at
Re: Adarsh Sharma 2018-06-07
> *drwx-- 2 postgres postgres 163840 Mar 19 18:18 2567078690*
> *drwx-- 2 postgres postgres 237568 Mar 19 19:10 2567168798*
> *drwx-- 2 postgres postgres 151552 Mar 19 19:19 2567176994*
> *drwx-- 2 postgres postgres 172032 Mar 19 19:34 2567193375*
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 fedora's to my invariably outdated version of Fedora
> by
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: Ubun
Re: Julián Jiménez González 2018-02-21
> I need and would greatly appreciate any help tracking this problem down.
I'd try setting gdb breakpoints on the relevant code lines/functions.
If it helps, old Ubuntu packages are available there:
http://atalia.postgresql.org/morgue/
https://wiki.postgre
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 -I
18 matches
Mail list logo
