On Fri, Nov 15, 2019 at 03:17:17PM -0500, Dave Hughes wrote:
> Thanks for replying guys! You both led me down the right path. I didn't
> realize it, but looks like we had 2 directories where psql was installed.
> Once I gave the path specifically to PostgreSQL10, it worked like a charm.
>
> I'm
Thanks for replying guys! You both led me down the right path. I didn't
realize it, but looks like we had 2 directories where psql was installed.
Once I gave the path specifically to PostgreSQL10, it worked like a charm.
I'm reaching out to our server admins now to see why there are 2
instances.
## Dave Hughes (dhughe...@gmail.com):
> However when I try to log in now, via command line, I receive the error:
> "psql: authentication method 10 not supported".
Your client (more precisely: it's libpq) is not ready for SCRAM.
I guess you're using an older (<10) client version? Mixed up
packages
On 11/15/19 8:23 AM, Dave Hughes wrote:
Hello,
We're currently using PostgreSQL version 10.5 in a Linux environment.
We were wanting to change the password authentication from MD5 to
SCRAM-SHA-256. I performed these steps to do so:
1) Modified the postgresql.conf and changed the password_encr
Hello,
We're currently using PostgreSQL version 10.5 in a Linux environment. We
were wanting to change the password authentication from MD5 to
SCRAM-SHA-256. I performed these steps to do so:
1) Modified the postgresql.conf and changed the password_encryption entry
from "md5" to "scram-sha-256".
