Attention

This document was written for an unsupported version of Plone, Plone 2.5.x, and was last updated 1240 days ago.

For more information, see the version support policy.

To learn how to upgrade to the current version of Plone, read the upgrade manual.

PostgreSQL support for Archetype Storage

by Chris Bier — last modified Dec 30, 2008 03:03 PM
How to add support for PostgreSQL storage to Archetype Storage fields in Zope and Plone using psycopg
  1. Make sure you have the PostgreSQL dev packages installed. (libpq-fe.h is required to build psycopg)
  2. Download the latest version of psycopg
  3. Extract it and run:
    • python setup.py build
    • python setup.py install
  4. Copy the ZPsycopgDA directory to your Zope Products directory
  5. Restart your Zope instance
  6. Add a database connector (It's listed in my ZMI Add listbox as "Z Psycopg 2 Database Connection") as in:

Contribute

Something wrong or out of date? Anybody can edit or create a new article in the knowledge base. Simply create an account on this site, log in, and click the Edit button to contribute.