[Bug 1670449] Re: Trove guest agent has postgres 9.4 configuration template. Ubuntu 16 database guests support only postgres 9.5

[Frank Heimes]

** Tags added: openstack-ibm

** Also affects: trove
   Importance: Undecided
       Status: New

** Package changed: openstack-trove (Ubuntu) => ubuntu-z-systems

-- 
You received this bug notification because you are a member of Ubuntu
OpenStack, which is subscribed to openstack-trove in Ubuntu.
https://bugs.launchpad.net/bugs/1670449

Title:
  Trove guest agent has postgres 9.4  configuration template. Ubuntu 16
  database guests support only postgres 9.5

Status in OpenStack DBaaS (Trove):
  New
Status in Ubuntu on IBM z Systems:
  New

Bug description:
  ---Problem Description---
  checkpoint_segment parameter in Trove configuration template prohibits postgres9.5 from starting. It needs to be removed. 

  The name of the .pid file changes in postgres9.5 and needs to be
  changed accordingly in trove code

  Trove checks first for upstart to start/stop database service and if exist, doesn't check for systemd files. can not start all postgres services with init . It needs to check first for systemd to start/stop database service.
   
  ---uname output---
  Linux zhyp169 4.4.0-47-generic #68-Ubuntu SMP Wed Oct 26 19:42:36 UTC 2016 s390x s390x s390x GNU/Linux
   
  Machine Type = KVM guest on s390 lpar 
    
  ---Steps to Reproduce---
  1. Create an Ubuntu 16.04 database image for postgresql
  2. Add a postgresql datastore to your OpenStack Trove environment
  3. Launch a DB instance using this image and this datastore for postgresql
   
  Userspace tool common name: trove guest agent 
   
  Userspace package: trove-guestagent

To manage notifications about this bug go to:
https://bugs.launchpad.net/trove/+bug/1670449/+subscriptions