Bug 890183

Summary:	packstack: postgres support for database
Product:	Red Hat OpenStack	Reporter:	Perry Myers <pmyers>
Component:	openstack-packstack	Assignee:	Martin Magr <mmagr>
Status:	CLOSED WONTFIX	QA Contact:	yeylon <yeylon>
Severity:	medium	Docs Contact:
Priority:	medium
Version:	1.0 (Essex)	CC:	aortega, apevec, bsettle, derekh, kbasil, markmc, mmagr, oblaut, sclewis, srevivo
Target Milestone:	---	Keywords:	FutureFeature, Triaged, ZStream
Target Release:	5.0 (RHEL 7)
Hardware:	Unspecified
OS:	Unspecified
URL:	https://review.openstack.org/#/c/19653/
Whiteboard:
Fixed In Version:		Doc Type:	Enhancement
Doc Text:		Story Points:	---
Clone Of:	816316	Environment:
Last Closed:	2015-08-14 14:44:18 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:
Bug Depends On:	890175, 990589
Bug Blocks:	816316

Description Perry Myers 2012-12-25 15:08:59 UTC

+++ 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

Comment 1 Perry Myers 2012-12-25 15:15:31 UTC

@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

Comment 2 Flavio Percoco 2013-01-14 17:38:06 UTC

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}).

Comment 3 Flavio Percoco 2013-01-31 11:01:11 UTC

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

Comment 4 Martin Magr 2013-07-31 08:29:07 UTC

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.