Installing psycopg on Red Hat 9
31st December 2003
Adrian Holovaty and I spent some time today figuring out how to get the psycopg Postgres module to install on Red Hat 9. It took a while, but eventually we tweaked the spec file and used it to compile our own RPM. I’ve posted our modified spec file to the psycopg mailing list. More for my own record than anything else, the arcane incantations needed to create the RPM went roughly as follows:
- Copy the modified psycopg.spec file in to /usr/src/redhat/SPECS/
- Copy psycopg-1.1.11.tar.gz in to /usr/src/redhat/SOURCES
- In the SPECS directory, run rpmbuild -ba psycopg.spec
- Install the resulting RPM, which materialised in /usr/src/redhat/RPMS
The above was recreated by digging through my bash history—hopefully I haven’t missed a step. The technique appears to work for Fedora as well.
More recent articles
- Phoenix.new is Fly's entry into the prompt-driven app development space - 23rd June 2025
- Trying out the new Gemini 2.5 model family - 17th June 2025
- The lethal trifecta for AI agents: private data, untrusted content, and external communication - 16th June 2025