Octavia installation on psql( Alembic DB migration for postgresql)

asked 2020-03-03 02:08:05 -0600

ArunVinod gravatar image

The latest available documentation for Octavia https://docs.openstack.org/octavia/latest/install/install-ubuntu.html#prerequisites (https://docs.openstack.org/octavia/la...) does not include the provisions to install octaiva with postgresql database

Managed to create db, users but while trying to populate the octavia database in psql using command "octavia-db-manage --config-file /etc/octavia/octavia.conf upgrade head" gives error.

The octaiva alembic migration codes seems to assume that the database is mysql and does not treat the psql database.

eg: /usr/lib/python2.7/site-packages/octavia/db/migration/alembic_migrations/versions/fac584114642_.py op.execute("ALTER TABLE health_monitor DROP PRIMARY KEY," "ADD PRIMARY KEY(id);")

The above code is intended for mysql datanbase and not postgresql.

Please guide how to do octavia db migration for postgresql.

edit retag flag offensive close merge delete

1 answer

Sort by ยป oldest newest most voted

answered 2020-03-03 13:24:32 -0600

johnsom gravatar image


This is correct. OpenStack overall (not just Octavia) stopped testing with postgresql some time ago [1] (Pike I think).

If you have a need to use a postgresql database with Octavia I would recommend the following: 1. Open a story on Storyboard for Octavia: https://storyboard.openstack.org/#!/p... with the bug you are seeing. Maybe another to track an RFE for adding postgresql support. 2. Join one of the Octavia IRC weekly meetings and raise the discussion of adding support/testing for postgresql.

We may have some base work in getting devstack/tempest gates to support postgresql.

Also, let the team know if you can help with this effort.

[1] https://review.opendev.org/#/c/678496/

edit flag offensive delete link more

Get to know Ask OpenStack

Resources for moderators

Question Tools

1 follower


Asked: 2020-03-03 02:08:05 -0600

Seen: 69 times

Last updated: Mar 03