Re: Regarding scram authentication libpq version 10 or more

[Durgamahesh Manne <maheshpostgres9@xxxxxxxxx>]

On Fri, Oct 6, 2017 at 3:40 PM, Michael Paquier <michael.paquier@xxxxxxxxx> wrote:

On Fri, Oct 6, 2017 at 5:44 PM, Durgamahesh Manne
<maheshpostgres9@xxxxxxxxx> wrote:
> This is regarding scram authentication libpq version 10. From which site  i
> can download to configure libpq in order to use scram authentication in
> postgres 10
>
> i got below error while i check to access pg server
>
> psql.bin: SCRAM authentication requires libpq version 10 or more
>
> please let me know the detail info about scram libpq

Why not beginning to look at the download page of postgresql.org? Here
is the page:
https://www.postgresql.org/download/
SCRAM/SASL support in libpq is provided in any build of PostgreSQL 10,
so this depends mainly on the distribution and environment you are
using.

In order to get support for SCRAM, the documentation provides enough
details, beginning here:
https://www.postgresql.org/docs/10/static/auth-methods.html#auth-password
Basically you need to consider using password_encryption =
'scram-sha-256', and configure pg_hba.conf with a correct entry. If
you are upgrading from an existing instance, you need to make sure
that users with passwords are updated with proper SCRAM-hashed
entries.
--
Michael

Hi sir

As per above mail conversation

i have already read complete info about New Postgres 10 in postgres.org  and i have tried to access server  by adding the
scram-sha-256 authentication in hba.conf and also have already set password_encyption = scram-sha-256 in config then reloaded the server for multiple times

still i am getting same error i given you earlier while i check to access pg server with required credentials

psql.bin: SCRAM authentication requires libpq version 10 or above

i am using linux mint distrib

DISTRIB_ID=LinuxMint
DISTRIB_RELEASE=17.1
DISTRIB_CODENAME=rebecca
DISTRIB_DESCRIPTION="Linux Mint 17.1 Rebecca"
::::::::::::::
/etc/os-release
::::::::::::::
NAME="Ubuntu"
VERSION="14.04.3 LTS, Trusty Tahr"
ID=ubuntu
ID_LIKE=debian
PRETTY_NAME="Ubuntu 14.04.3 LTS"
VERSION_ID="14.04"

 Regards

durgamahesh m