On Mon, Jul 23, 2018 at 6:36 PM, Dave Page <dp...@pgadmin.org> wrote:
> Hi Akshay > > On Mon, Jul 23, 2018 at 2:03 PM, Akshay Joshi < > akshay.jo...@enterprisedb.com> wrote: > >> Hi Hackers, >> >> A new password encryption method "*scram-sha-256*" has been introduce in >> PostgreSQL10. Along with that a new method "*PQencryptPasswordConn*" has >> been exposed to get the encrypted password. This new method is not >> supported in "psycopg2". Ashesh has send the patch https://github.com/ >> psycopg/psycopg2/pull/576 and has been merged into the master branch of >> psycopg2 and will be available in their next release 2.8 >> >> "*Change password*" functionality was not working, as pgAdmin4 not able >> to encrypt the password in scram. I have downloaded the latest code of >> psycopg2, compile it with libpq version 10 and implement the logic in >> pgAdmin4. >> >> Attached is the patch to fix that issue. Please review it. >> > > Cool. Do you have any tips or hints on the easiest way to build psycopg2 > from the tree, without using PIP? > Steps on Ubuntu 18.04 64 bit: - Clone psycopg2 from *https://github.com/psycopg/psycopg2.git <https://github.com/psycopg/psycopg2.git>* - Activate the virtual environment. - Add path of PostgreSQL 10(/opt/PostgreSQL/10/bin) to PATH variable, so that psycopg2 will compile against libpq version greater or equal to 100000. - Go to the psycopg2 folder and run the following: - python setup.py build - python setup.py install - It will create psycopg2-2.8.dev0-py2.7-linux-x86_64.egg - Remove/Move all other folders or files with the name of "psycopg2" from site-packages. > > -- > Dave Page > Blog: http://pgsnake.blogspot.com > Twitter: @pgsnake > > EnterpriseDB UK: http://www.enterprisedb.com > The Enterprise PostgreSQL Company > -- *Akshay Joshi* *Sr. Software Architect * *Phone: +91 20-3058-9517Mobile: +91 976-788-8246*
