Psycopg is the most popular PostgreSQL adapter for the Python programming language. Its core is a complete implementation of the Python DB API 2.0 specifications. Several extensions allow access to many of the features offered by PostgreSQL.

Psycopg is released under the terms of the GNU Lesser General Public License, allowing use from both free and proprietary software.

For help requests and development discussions please subscribe to the mailing list psycopg@postgresql.org.

Latest articles

Psycopg 2.8.4 released

Posted by Daniele Varrazzo on 2019-10-20
Tagged as news, release

Psycopg 2.8.4 has been released.

The release brings a few assorted bugfixes and adds support for Python 3.8 and PostgreSQL 12.

Read more...

Psycopg 2.8.3 released

Posted by Daniele Varrazzo on 2019-06-14
Tagged as news, release

We have released Psycopg 2.8.3, which includes a slight change to the logical replication.

Choosing the right frequency to send replication feedback messages from the client to the server was previously the developer's responsibility, with too many feedback messages being a waste of bandwidth and server resources, too few slowing down WAL cleanup and possibly preventing a server graceful shutdown.

Read more...

Psycopg 2.8.1, 2.8.2 released

Posted by Daniele Varrazzo on 2019-04-14
Tagged as news, release

Hello,

We have just released Psycopg 2.8.2; a few days ago Psycopg 2.8.1 was released.

Some of the bugs addressed are ordinary teething problem with the 2.8 release, but an important change landed with 2.8.2: binary packages now ship with OpenSSL 1.1 instead of 1.0. This should fix concurrency problems on connection experienced both on Windows and Linux. Many thanks to Matthew Brett and Jason Erickson for this improvement!

Read more...

See all articles...