Re: Regarding scram authentication libpq version 10 or more

On Fri, Oct 6, 2017 at 3:40 PM, Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
wrote:

> On Fri, Oct 6, 2017 at 5:44 PM, Durgamahesh Manne
> <maheshpostgres9(at)gmail(dot)com> 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