+++ This bug was initially created as a clone of Bug #816316 +++ Description of problem: Presently upstream OpenStack primarily utilizes mysql for its database. We'd like to expand this to include postgres in addition. There are probably some integration issues/small problems with running Postgres w/ Essex today, and these bugs will need to be tracked and individually resolved separately. This bug is specifically for tracking the overall support of Postgres, and as such is a TestOnly bug. --- Additional comment from Perry Myers on 2012-04-25 15:14:39 EDT --- Related bugs: https://bugs.launchpad.net/glance/+bug/953159 https://bugs.launchpad.net/glance/+bugs?field.tag=postgresql
@derekh: I think this bug (unlike the other bugs for postgres support) involves some development work. We'd need to have puppet modules that target postgres in addition to mysql and give the cmdline packstack user the option to configure postgres as their backend db vs. mysql
There's puppet-postgresql that should handle the whole postgresql thing but it seems a bit buggy. So far the implementation seems to work and the changes in the code are not as big as expected. Keystone already supports postgresql but glance, cinder and nova don't. (talking about puppet-{module}).
General update: There were added psql manifests for nova, cinder, and glance. The three of them seem to work correctly and the current blocking issue right now is the fact that RHOS installs an older version of python-migrate which makes glance's db_sync fail. There's a bug filed for that issue: https://bugzilla.redhat.com/show_bug.cgi?id=879387
Looking at the puppet-(nova|glance|cinder) Postgresql support has been implemented or at least the basic support. It should be possible to implement the support in Packstack now. But fist "MySQL optional installation" patch should be merge so we can then just add also optional Postgresql installation.