RE: BUG #15035: scram-sha-256 blocks all logins

I suppose you can be terse all you like, this is the interwebz and any corner of it can quickly become 4chan when you don't demand money for your product.

Funny how big grown-up companies with costumers that pay for their product are:
1. Successful and long-lasting
2. Widespread across the market and are used by many other big and prosperous companies
3. Have technical support representatives that don't get butthurt when they don't pick up on their users' mistake, even when they're supposed to be knowledgeable about their own documentation.

Those big grown-up companies, they use Oracle, or SQL Server, or MySQL.

They don't use PostgreSQL.

-----Original Message-----
From: Tomas Vondra [mailto:tomas(dot)vondra(at)2ndquadrant(dot)com]
Sent: Tuesday, January 30, 2018 17:50
To: Meirav Rath <meirav(dot)rath(at)imperva(dot)com>; David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: Daniel Gustafsson <daniel(at)yesql(dot)se>; pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #15035: scram-sha-256 blocks all logins

On 01/30/2018 03:37 PM, Meirav Rath wrote:
> Actually, my job is to test our products’ compatibility with 13
> databases, PostgreSQL is one of them. I see a /lot /of documentation
> and so far PostgreSQL has been relatively friendly.
>
> However, this very roundabout way of saying things, so much so that
> you need to ask a PostgreSQL person how to interpret the phrasing is
> not user-friendly. After I’m done with PostgreSQL 10 new features’
> testing, I’m moving on to test other databases’ new versions and their
> features.
>

Great response to people who're helping you with your job for free.

Now consider that you've submitted something that is not a bug but an
issue with configuring pg_hba.conf properly. Generally, a bug report
requires some explanation of why the configuration is correct and what
the behavior should be.

We do see plenty of people posting such non-bug questions to psql-bugs
and we're somewhat annoyed by that. Most people however take the hint
and post the question to pgsql-general when asked to do so, instead of
attacking the people who are actually trying to help them.

I agree getting pg_hba.conf right is not simple, particularly if you do
it for the first time. But I don't see anything wrong with it, and you
don't explain what a better/simpler solution would look like. You'd have
to learn how any other solution works anyway - the principles would be
the same.

But complaining is simpler, I guess ...

What I find particularly strange is your response to David quoting the
documentation. Pointing you to the proper part of the docs is about the
best thing he could have done, the paragraph is technically accurate,
provides additional context about how pg_hba.conf works, and copying it
is much faster than typing the explanation by hand.

This is a mailing list and terse response are expected.

> If I was a DBA whose company considered moving to work with
> PostgreSQL, and I saw this obscure phrasing, and the clumsiness to
> this code, I’d tell my bosses to think twice about PostgreSQL and
> maybe try a sturdier database.
That's up to you. But perhaps your boss will see it differently.

regards

--
Tomas Vondra http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
-------------------------------------------
NOTICE:
This email and all attachments are confidential, may be proprietary, and may be privileged or otherwise protected from disclosure. They are intended solely for the individual or entity to whom the email is addressed. However, mistakes sometimes happen in addressing emails. If you believe that you are not an intended recipient, please stop reading immediately. Do not copy, forward, or rely on the contents in any way. Notify the sender and/or Imperva, Inc. by telephone at +1 (650) 832-6006 and then delete or destroy any copy of this email and its attachments. The sender reserves and asserts all rights to confidentiality, as well as any privileges that may apply. Any disclosure, copying, distribution or action taken or omitted to be taken by an unintended recipient in reliance on this message is prohibited and may be unlawful.
Please consider the environment before printing this email.