Re: LDAP on AIX build farm animals

On Thu, Mar 21, 2019 at 12:21:58PM +1300, Thomas Munro wrote: > On several AIX BF animals such as tern, I see evidence that it might > be using IBM LDAP: > > checking for ldap_initialize... no > Another explanation is that it is actually using OpenLDAP, but it's a > version so ancient that it doe

Re: LDAP authenticated session terminated by signal 11: Segmentation fault, PostgresSQL server terminates other active server processes

Thomas Munro writes: > On Wed, Mar 20, 2019 at 10:51 AM Tom Lane wrote: >> It's reasonable to assume that the proposed patch won't cause real issues >> on any modern platform, but I'm not sure we can assume that for old ones, >> so the whole thing is making me a bit nervous. > Sure, it's possibl

Re: LDAP authenticated session terminated by signal 11: Segmentation fault, PostgresSQL server terminates other active server processes

On Wed, Mar 20, 2019 at 10:51 AM Tom Lane wrote: > Thomas Munro writes: > > Even though I can't reproduce the problem myself, I'm quite keen to go > > ahead and push the patch I proposed for v12 anyway, and close this > > case. Otherwise this problem could just keep coming back until > > libldap

Re: LDAP on AIX build farm animals

Thomas Munro writes: > On several AIX BF animals such as tern, I see evidence that it might > be using IBM LDAP: > checking for ldap_initialize... no Interesting. > Would it be useful for the buildfarm to dump ldd (or equivalent) > output for the binaries it's running so that we can see which >

LDAP on AIX build farm animals

Hello, On several AIX BF animals such as tern, I see evidence that it might be using IBM LDAP: checking for ldap_initialize... no And yet the configure options apparently intended to use OpenLDAP: configure: using CPPFLAGS= -I/home/nm/sw/nopath/libxml2-32/include/libxml2 -I/home/nm/sw/nopath/uu

Re: AW: Postgres Enhancement Request

Hi Markus, Please see comment at the bottonm of this email! On 21/03/2019 05:36, Zwettler Markus (OIZ) wrote: Yes, that would be totally ok. Like the "with [grant|admin] option" privilege model in SQL. It should be done with all these predefined top-level database roles like CREATEROLE. It's

Re: Windows Server 2019 support state / plans

On 3/20/19 7:55 AM, Ephebopus wrote: Hi all We are looking to upgrade our hosting environment (hosted locally) from a Windows Server 2008 R2 and an older version of Postgresql (9.1.4). Googling "postgresql 'windows server 2019'" yields rather few results and the Downloads page for Windows insta

AW: Postgres Enhancement Request

Yes, that would be totally ok. Like the "with [grant|admin] option" privilege model in SQL. It should be done with all these predefined top-level database roles like CREATEROLE. It's doesn't only seem bogus but also a security hole when users can get privileges they have never been granted. Ma

Re: to_timestamp function

Gustavsson Mikael writes: > So my question is, is it intentional that to_timestamp is stricter than cast > to timestamp? Yes. The point of using that function at all is to be strict about the input format, so being strict about the field values seems to make sense along with that. An independe

to_timestamp function

Hi, We recently upgraded from PG9.6 to PG11 and I have some questions regarding the function to_timestamp. We have an application that for some reason unknown to me uses timestamps with hour = 24. After upgrade we got som problems with this. The solution is to use cast instead of the function

Windows Server 2019 support state / plans

Hi all We are looking to upgrade our hosting environment (hosted locally) from a Windows Server 2008 R2 and an older version of Postgresql (9.1.4). Googling "postgresql 'windows server 2019'" yields rather few results and the Downloads page for Windows installers lists Windows Server 2016 as the

Re: Postgres Enhancement Request

Thomas Kellerer writes: > Tom Lane schrieb am 20.03.2019 um 14:59: >> No, it wouldn't. The point of CREATEROLE is to allow user creation >> and deletion to be done by a role that's less than full superuser. >> If we changed it like that, then you'd be right back at needing >> superuser for very r

Re: Postgres Enhancement Request

Tom Lane schrieb am 20.03.2019 um 14:59: >>> Please prevent users with CREATEROLE to create roles having CREATEDB >>> (analogous SUPERUSER and REPLICATION). > >> I agree that would be a welcome enhancement. > > No, it wouldn't. The point of CREATEROLE is to allow user creation > and deletion t

Re: Postgres Enhancement Request

Thomas Kellerer writes: > Zwettler Markus (OIZ) schrieb am 20.03.2019 um 11:10: >> Please prevent users with CREATEROLE to create roles having CREATEDB >> (analogous SUPERUSER and REPLICATION). > I agree that would be a welcome enhancement. No, it wouldn't. The point of CREATEROLE is to allow

Re: Performance of ByteA: ascii vs binary

Am 19.03.19 um 20:37 schrieb Peter J. Holzer: On 2019-03-18 15:33:17 +0100, Thomas Güttler wrote: I did some benchmarking and in my setup there was major performance difference. I tested a ByteA column. If I used ascii data the tests took 52 seconds. If I used random binary data the test to

AW: Postgres Enhancement Request

We already did and use this at the moment. Unfortunately. Some out-of-the-box applications can't use functions for user management. Some users don't want "special" functions for user management. ... Markus -Ursprüngliche Nachricht- Von: Thomas Kellerer Gesendet: Mittwoch, 20. März 20

Re: subscription broken after upgrade to pg11

On Tue, Mar 19, 2019 at 10:37 PM Adrian Klaver wrote: > On 3/19/19 9:35 AM, Radoslav Nedyalkov wrote: > > Hi All, > > We're testing upgrade from postgres 10.6 to postgres 11.2 with > pg_upgrade. > > Before stopping pg10 we disabled subscription. > > After upgrade and launching pg11, the existing

Re: WSL (windows subsystem on linux) users will need to turn fsync off as of 11.2

Who areb Get Outlook for Android From: Thomas Munro Sent: Tuesday, February 19, 2019 5:31:26 AM To: James Sewell Cc: Andres Freund; Ravi Krishna; pgsql-generallists.postgresql.org Subject: Re: WSL (windows subsystem on linux) users will nee

Re: Postgres Enhancement Request

Zwettler Markus (OIZ) schrieb am 20.03.2019 um 11:10: > CREATEROLE allows users to create new roles also having the CREATEDB > privilege (at least in version 9.6). > > We want special users to be able to CREATEROLE without being able to CREATEDB > (eg. when usermanagement is done by the applicat

Postgres Enhancement Request

CREATEROLE allows users to create new roles also having the CREATEDB privilege (at least in version 9.6). We want special users to be able to CREATEROLE without being able to CREATEDB (eg. when usermanagement is done by the application itself). Please prevent users with CREATEROLE to create rol