Wednesday, 8 June 2005

Another Debian upgrade PSA

If your attempts to connect to your PostgreSQL database from psycopg fail with a missing socket error after upgrading from Debian sarge to etch or sid (as I inadvertently did yesterday), add "host=localhost" to the DSN string. Apparently the Unix domain socket was disabled in the default configuration, so database connections must now go through TCP/IP. This may affect other database adapters too.