Upgrade Postgresql guest to version 9.6

[Doug Shelley]

Current guest code and image elements work for Postgresql 9.4. Upgrade to support v9.6

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: master
Review: https://review.openstack.org/409524

[jian.song (jiansong)]

Update some information, yesterday tried to install postgresql 9.6 on fedora22 , but it seems that there is no postgresql9.6 yum repo for fedora22, I now find the postgresql 9.6 on fedora25 +. We seem to choose a later version of fedora. I also updated this information to erthpad.

https://etherpad.openstack.org/p/trove-ptg-rocky

[zhanggang (gangzh)]

Is there has conclusion that we doesn't support postgresql anymore.

[jian.song (jiansong)]

Not yet, but according to the survey, it is not possible to install postgresql9.6 on fedora22.Or there is something I did not investigate.

[jian.song (jiansong)]

https://rpmfind.net/linux/rpm2html/search.php?query=pkgconfig(libecpg)

This may also be a reference here

[zhanggang (gangzh)]

I didn't test it on fedora, just install pg 9.6 on ubuntu 12.04 manually, and it works

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: master
Review: https://review.openstack.org/534667

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/534667
Committed: https://git.openstack.org/cgit/openstack/trove/commit/?id=75bc5a48df89c9f8396bbe18665109d65ee89490
Submitter: Zuul
Branch: master

commit 75bc5a48df89c9f8396bbe18665109d65ee89490
Author: zhanggang <email address hidden>
Date: Wed Jan 17 16:03:44 2018 +0800

    Upgrade Postgresql support to v9.6

    Modified existing Postgresql elements to support v9.6.
    This change will no longer support pg<9.6, so "wal_log_hints"
    is supported by default. Remove "checkpoint_segments" from
    config.template because the parameter is no longer supported
    from 9.5. By defult, "trovestack kick-start postgresql" will
    create a pg-9.6 image. The steps in "30-postgresql" has been
    tested in ubuntu trusty. Since yum.postgresql.org is no longer support
    fedora-22[1], trovestack use fedora-27 by default, and steps in
    "10-postgresql" has been tested too.
    Releated commits: https://review.openstack.org/#/c/409524/
    [1] https://yum.postgresql.org/9.6/fedora/
    Closes-bug: 1649084

    Change-Id: I65d93635ad45838522abed014825d1f7e567c30c

[OpenStack Infra (hudson-openstack)]

Change abandoned by Manoj Kumar (<email address hidden>) on branch: master
Review: https://review.openstack.org/409524
Reason: Already merged as part of
https://review.openstack.org/#/c/534667/

[OpenStack Infra (hudson-openstack)]

This issue was fixed in the openstack/trove 9.0.0.0b3 development milestone.