Re: Seeking practice recommendation: is there ever a use case to have two or more superusers?

2022-11-21 Thread David G. Johnston
On Mon, Nov 21, 2022 at 5:30 PM Adrian Klaver wrote: > On 11/21/22 15:05, Bryn Llewellyn wrote: > > > > In fact, David Johnston did unequivocally challenge my strawman a couple > of turns back, thus: > > > > > And the equivocal additions later in the post: > Yeah, even when I try to be

Re: Seeking practice recommendation: is there ever a use case to have two or more superusers?

2022-11-21 Thread Adrian Klaver
On 11/21/22 15:05, Bryn Llewellyn wrote: adrian.kla...@aklaver.com wrote: ...why the "Nobody supports it!" statement for a recommendation that only appeared at the same time? I for one have a poor record of mind reading and/or predicting the future:) Here’s what I wrote in the post that

Re: Seeking practice recommendation: is there ever a use case to have two or more superusers?

2022-11-21 Thread Gavan Schneider
On 22 Nov 2022, at 10:05, Bryn Llewellyn wrote: > Because PG allows a cluster to have as many superusers as you please, and > because any one of these can create or drop another, any convention in this > space needs some extra mechanisms to enforce it.. > > … effectively tamper-proof

Re: Seeking practice recommendation: is there ever a use case to have two or more superusers?

2022-11-21 Thread David G. Johnston
On Mon, Nov 21, 2022 at 4:05 PM Bryn Llewellyn wrote: > > I believe that the fact that a superuser's ability to start a session can > be limited by what the "hba_file" says is critical here—together with the > fact that the ability to edit this file is governed by the regime of O/S > users and

Re: Seeking practice recommendation: is there ever a use case to have two or more superusers?

2022-11-21 Thread Bryn Llewellyn
> adrian.kla...@aklaver.com wrote: > >> b...@yugabyte.com wrote: >> >> Consider this wording. It also uses “good practice”. >> >> « >> It is good practice to limit the number of superuser roles that exist in a >> cluster to exactly one: the inevitable bootstrap superuser. This recognizes >>

Re: Seeking practice recommendation: is there ever a use case to have two or more superusers?

2022-11-21 Thread Adrian Klaver
On 11/21/22 11:46, Bryn Llewellyn wrote: Nobody supports it! I went back through the thread and don't anywhere when you made the above statement, correct me if I am wrong. In that case there was nothing to support or not support until now. What people where responding to the title of the

Re: Seeking practice recommendation: is there ever a use case to have two or more superusers?

2022-11-21 Thread Bryn Llewellyn
> adrian.kla...@aklaver.com wrote: > >> b...@yugabyte.com: >> >> Consider this wording. It also uses “good practice”. >> « >> It is good practice to limit the number of superuser roles that exist in a >> cluster to exactly one: the inevitable bootstrap superuser. This recognizes >> the fact

Re: Seeking practice recommendation: is there ever a use case to have two or more superusers?

2022-11-21 Thread David G. Johnston
On Mon, Nov 21, 2022 at 10:40 AM Bryn Llewellyn wrote: > > Consider this wording. It also uses “good practice”. > > « > It is good practice to limit the number of superuser roles that exist in a > cluster to exactly one: the inevitable bootstrap superuser. This recognizes > the fact that, once

Re: Seeking practice recommendation: is there ever a use case to have two or more superusers?

2022-11-21 Thread Adrian Klaver
On 11/21/22 9:40 AM, Bryn Llewellyn wrote: adrian.kla...@aklaver.com wrote: Then there’s this (from the doc): It is good practice to create a role that has the CREATEDB and CREATEROLE privileges, but is not a superuser, and then use this role for all routine management of databases and

Re: Getting PSQL in Windows to support TAB/Autocomplete via modified readline...

2022-11-21 Thread Dominique Devienne
On Mon, Nov 21, 2022 at 6:12 PM Kirk Wolak wrote: > On Mon, Nov 21, 2022 at 11:01 AM Dominique Devienne > wrote: > > FWIW, I've been using https://github.com/arangodb/linenoise-ng for Linux > > and Windows, > > I've look at linenoise and without tab/autocomplete it's not worth the > effort,

Re: Seeking practice recommendation: is there ever a use case to have two or more superusers?

2022-11-21 Thread Bryn Llewellyn
> adrian.kla...@aklaver.com wrote: > >> karsten.hilb...@gmx.net: >> >>> adrian.kla...@aklaver.com wrote: >>> b...@yugabyte.com Thanks to all who offered their views on my question. It seems that different people will reach different conclusions. I’ll take this as

Re: Getting PSQL in Windows to support TAB/Autocomplete via modified readline...

2022-11-21 Thread Kirk Wolak
On Mon, Nov 21, 2022 at 10:58 AM Tom Lane wrote: > It'd certainly be nice if we could use Readline on Windows. I do not > think we want to buy into maintaining our own fork of Readline, if that's > what you're trying to suggest. If it "just works" now, that'd be great. > Okay, we should know

Re: Getting PSQL in Windows to support TAB/Autocomplete via modified readline...

2022-11-21 Thread Dominique Devienne
On Mon, Nov 21, 2022 at 4:58 PM Tom Lane wrote: > Kirk Wolak writes: > > We have our team of Windows developers, leveraging PSQL. But honestly, > > it feels crippled after using PSQL in Linux for any length of time. Losing > > auto-complete sucks (multi-line query recall/editing is lost as

Re: Getting PSQL in Windows to support TAB/Autocomplete via modified readline...

2022-11-21 Thread Tom Lane
Kirk Wolak writes: > We have our team of Windows developers, leveraging PSQL. But honestly, > it feels crippled after using PSQL in Linux for any length of time. Losing > auto-complete sucks (multi-line query recall/editing is lost as well). > In researching this problem, it appears that

Getting PSQL in Windows to support TAB/Autocomplete via modified readline...

2022-11-21 Thread Kirk Wolak
First, I wanted to send this to the developers (hackers) list. But the instructions are clear that initial posts don't go there (try elsewhere first). So playing by the rules here... *Background:* We have our team of Windows developers, leveraging PSQL. But honestly, it feels crippled

Looking for onchain EVM Postgres port

2022-11-21 Thread Myles Dear
Hello, it’s Myles over at https://CanaDAO.org. We’re planning to port and adapt https://liquidfeedback.org on top of the Ethereum Virtual Machine. We’re looking for a full PostGres port on top of Radix/Notoros (running in a write once read many paradigm of course, due to on chain

Re: ERROR: could not find pathkey item to sort

2022-11-21 Thread Vijaykumar Sampat Jain
fyi. The issue was fixed with this PR. https://github.com/adjust/parquet_fdw/pull/60 Thanks, Vijay On Fri, Oct 28, 2022 at 7:59 PM Vijaykumar Sampat Jain < vijaykumar.sampat.j...@adjust.com> wrote: > On Fri, Oct 28, 2022 at 7:15 PM Tom Lane wrote: > > > > > > I think it's most likely a bug in