Latest articles

Psycopg 2.7.1 released

Posted by Daniele Varrazzo on 2017-03-13
Tagged as news, release

A quick bugfix release to solve some teething problems with some of the changes introduced in 2.7:

  • Ignore None arguments passed to connect() and make_dsn() (ticket #517).
  • OpenSSL upgraded from major version 0.9.8 to 1.0.2 in the Linux wheel packages (ticket #518).
  • Fixed build with libpq versions < 9.3 (ticket #520).

Read more...

Psycopg 2.7 released

Posted by Daniele Varrazzo on 2017-03-01
Tagged as news, release

Finally here! Thank you very much for waiting so long: we have finally released Psycopg 2.7!

Buzzwords:

  • Faster! Helps generating SQL for repeatedly executed statements and faster Unicode decoding.
  • Safer! Helps generating dynamic SQL statements with variable table and field names.
  • Easier! Use the binary package to avoid the need of C compiler, pg_config, libpq required on the clients.
  • Replication! Support for PostgreSQL physical and logical replication.
  • Plays-better-with-pgbouncer-at-transaction-pooling-level! This.

Read more...

Psycopg 2.7 beta 2 released

Posted by Daniele Varrazzo on 2017-02-17
Tagged as news, release

Hello,

we have released psycopg2 version 2.7 beta 2. This version comes two years after the previous major release so it is packed with new features and improvements; among the main points:

Read more...

Psycopg 2.6.2 released

Posted by Daniele Varrazzo on 2016-07-07
Tagged as news, release

Psycopg 2.6.2 has been released. You can get it from:

This is an interim release, packing together one year of bug fixes, before the release 2.7, intended to deliver several new features. Thank you very much to everybody contributing with reports, code, suggestions.

Read more...

Psycopg 2.6.1 released

Posted by Daniele Varrazzo on 2015-06-16
Tagged as news, release

Psycopg 2.6.1 has been released. You can get it from:

Read more...

Psycopg 2.6 and 2.5.5 released

Posted by Daniele Varrazzo on 2015-02-09
Tagged as news, release

We have just released two Psycopg versions: 2.5.5 containing a few bug fixes and 2.6 introducing some new features.

Read more...

Psycopg 2.5.4 released

Posted by Daniele Varrazzo on 2014-08-30
Tagged as news, release

Psycopg 2.5.4 has been released. You can get it from:

This version supports the new jsonb PostgreSQL type out-of-the-box. And of course there are a few bug fixed:

Read more...

Cancelling PostgreSQL statements from Python

Posted by Daniele Varrazzo on 2014-07-20
Tagged as recipe

Cancelling a long running query from Python is not something that happens automatically: the libpq doesn't react to Python signals so the only way to stop a query is to run a pg_cancel_backend from another process. Killing the Python process won't cancel the query: it will run until completion and then rolled back. This makes working wth long-running query from the Python interpreter somewhat frustrating.

Read more...

Psycopg 2.5.3 Released

Posted by Daniele Varrazzo on 2014-05-13
Tagged as news, release

Psycopg 2.5.3 has been released. You can get it from:

This version contains several bug fixes over the previous release 2.5.2:

Read more...

Psycopg 2.5.2 released

Posted by Daniele Varrazzo on 2014-01-07
Tagged as news, release

Psycopg 2.5.2 has been released. You can get it from:

This version contains a few bug fixes over the previous release 2.5.1:

  • Fixed segfault pickling the exception raised on connection error (ticket #170).
  • Meaningful connection errors report a meaningful message, thanks to Alexey Borzenkov (ticket #173).
  • Manually creating lobject with the wrong parameter doesn't segfault (ticket #187).

Thank you very much to all the people who helped during the development!