BDR and PostgreSQL 12 and Windows support

I've seen that BDR may be rolled into core PostgreSQL version 12 and was wondering if anyone knows if that BDR support will be extended to Windows or if it will remain a non-WIndows feature. Thanks, Paul Judson paul.jud...@microfocus.com

Re: BDR and PostgreSQL 12 and Windows support

On Fri., 16 Nov. 2018, 8:39 pm Paul Judson I've seen that BDR may be rolled into core PostgreSQL version 12 and was > wondering if anyone knows if that BDR support will be extended to Windows > or if it will remain a non-WIndows feature. > I've been waiting for years for multi master support in P

Re: Impact on PostgreSQL due to Redhat acquisition by IBM

On Thu, Nov 15, 2018 at 5:07 PM Adrian Klaver wrote: > On 11/15/18 7:59 AM, Sachin Kotwal wrote: > > > > > > On Thu 15 Nov, 2018, 7:59 PM Adrian Klaver > wrote: > > > > On 11/14/18 10:39 PM, Sachin Kotwal wrote: > > > Hope Redhat community support w

Re: BDR and PostgreSQL 12 and Windows support

Andrew Smith schrieb am 16.11.2018 um 11:01: > Are there any core features at the > moment that are Linux only? JIT, introduced in Postgres 11, comes to mind

Re: BDR and PostgreSQL 12 and Windows support

> > Andrew Smith schrieb am 16.11.2018 um 11:01: >> Are there any core features at the >> moment that are Linux only? > > JIT, introduced in Postgres 11, comes to mind > A better question should be, are there any production users of PG on Windows :-)

Re: BDR and PostgreSQL 12 and Windows support

Le 16/11/2018 à 15:28, Ravi Krishna a écrit : A better question should be, are there any production users of PG on Windows :-) And the answer is yes, there are some ! Cheers -- Arnaud

Re: Prevent locked state (row lock + alter table)

Hello! We have found some solutions here: https://leopard.in.ua/2016/09/20/safe-and-unsafe-operations-postgresql#.W-7bFEeYWHs https://dba.stackexchange.com/questions/132851/database-frozen-on-alter-table Best regards dd Durumdara ezt írta (időpont: 2018. okt. 5., P, 14:55): > Dear Member

RE: BDR and PostgreSQL 12 and Windows support

-Original Message- From: Ravi Krishna [mailto:srkrish...@icloud.com] Sent: Friday, November 16, 2018 9:28 AM To: Thomas Kellerer Cc: pgsql-general Subject: Re: BDR and PostgreSQL 12 and Windows support WARNING: This email originated from outside of Perceptron! Please be mindful of PH

Re: BDR and PostgreSQL 12 and Windows support

On Fri, Nov 16, 2018 at 3:15 PM Thomas Kellerer wrote: > Andrew Smith schrieb am 16.11.2018 um 11:01: > > Are there any core features at the > > moment that are Linux only? > > JIT, introduced in Postgres 11, comes to mind > JIT is not Linux only. It currently does not work on Windows AFAIK, bu

Re: Question about index on different tablespace and rebuild it

Yes, I know. My question is: Did the pg server will start at all if the NVME / table space somehow is broken and indexes is unable to be loaded, not how to drop an index. Since the Postgre server is not starting at all maybe I can try dropping my indexes on my pocket calculator all day long.

Re: WTF with hash index?

Greetings, * Олег Самойлов (spl...@ya.ru) wrote: > Ah, thanks. I am not a developer of PostgreSQL. I am a developer in > PostgreSQL. :) And I see two hash indexes on the same data and one of them 43 > times bigger then other, this looked like something terribly wrong. Just free > idea how to co

Re: Default Privilege Table ANY ROLE

Greetings, * Tom Lane (t...@sss.pgh.pa.us) wrote: > Maybe I'm missing something, but doesn't this solve your problem > as stated? > > ALTER DEFAULT PRIVILEGES IN SCHEMA myschema GRANT SELECT ON TABLES TO public; That just means that the 'ROLE' in the result is the current role, as per the docs:

Re: Default Privilege Table ANY ROLE

Stephen Frost writes: > There was much discussion of being able to have 'FOR ALL ROLES' or > similar for ALTER DEFAULT PRIVILEGES when it went in, but there was a > lot of concern about one user getting to define the default privileges > for objects created by some other user. Yeah, it's hard to