On Fri, Oct 6, 2017 at 3:40 PM, Michael Paquier <michael.paqu...@gmail.com> wrote:
> On Fri, Oct 6, 2017 at 5:44 PM, Durgamahesh Manne > <maheshpostgr...@gmail.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