Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.
Red Hat Satellite engineering is moving the tracking of its product development work on Satellite to Red Hat Jira (issues.redhat.com). If you're a Red Hat customer, please continue to file support cases via the Red Hat customer portal. If you're not, please head to the "Satellite project" in Red Hat Jira and file new tickets here. Individual Bugzilla bugs will be migrated starting at the end of May. If you cannot log in to RH Jira, please consult article #7032570. That failing, please send an e-mail to the RH Jira admins at rh-issues@redhat.com to troubleshoot your issue as a user management inquiry. The email creates a ServiceNow ticket with Red Hat. Individual Bugzilla bugs that are migrated will be moved to status "CLOSED", resolution "MIGRATED", and set with "MigratedToJIRA" in "Keywords". The link to the successor Jira issue will be found under "Links", have a little "two-footprint" icon next to it, and direct you to the "Satellite project" in Red Hat Jira (issue links are of type "https://issues.redhat.com/browse/SAT-XXXX", where "X" is a digit). This same link will be available in a blue banner at the top of the page informing you that that bug has been migrated.

Bug 1195940

Summary: katello-service do not handle PostgreSQL service
Product: Red Hat Satellite Reporter: Jan Hutař <jhutar>
Component: Content ManagementAssignee: Brad Buckingham <bbuckingham>
Status: CLOSED ERRATA QA Contact: jcallaha
Severity: medium Docs Contact:
Priority: unspecified    
Version: 6.1.0CC: bbuckingham, jcallaha, lpramuk
Target Milestone: UnspecifiedKeywords: Triaged
Target Release: Unused   
Hardware: Unspecified   
OS: Unspecified   
URL: http://projects.theforeman.org/issues/11648
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2016-07-27 09:13:48 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:

Description Jan Hutař 2015-02-24 21:22:35 UTC
Description of problem:
katello-service do not handle PostgreSQL service


Version-Release number of selected component (if applicable):
Satellite-6.1.0-RHEL-6-20150220.0-Satellite-x86_64


How reproducible:
always


Steps to Reproduce:
1. # katello-service stop
2. # service postgresql status


Actual results:
PostgreSQL is still running


Expected results:
PostgreSQL should be stopped by `katello-service stop`

Comment 1 RHEL Program Management 2015-02-24 23:14:27 UTC
Since this issue was entered in Red Hat Bugzilla, the release flag has been
set to ? to ensure that it is properly evaluated for this release.

Comment 3 Brad Buckingham 2015-09-01 20:14:38 UTC
Created redmine issue http://projects.theforeman.org/issues/11648 from this bug

Comment 4 Brad Buckingham 2015-09-01 20:20:34 UTC
katello-packing PR: https://github.com/Katello/katello-packaging/pull/76

Comment 5 Bryan Kearney 2015-09-01 22:03:20 UTC
Upstream bug component is Content Management

Comment 6 Bryan Kearney 2015-10-21 20:07:34 UTC
Moving to POST since upstream bug http://projects.theforeman.org/issues/11648 has been closed

Comment 7 jcallaha 2015-11-10 21:41:23 UTC
Verified in upstream. katello-service now includes postgres.

[root@qe-blade-12 ~]# katello-service stop
Redirecting to /bin/systemctl stop  mongod.service
Redirecting to /bin/systemctl stop  postgresql.service
Redirecting to /bin/systemctl stop  qpidd.service
Redirecting to /bin/systemctl stop  qdrouterd.service
Redirecting to /bin/systemctl stop  tomcat.service
Redirecting to /bin/systemctl stop  foreman-proxy.service
Redirecting to /bin/systemctl stop  pulp_workers.service
Redirecting to /bin/systemctl stop  pulp_celerybeat.service
Redirecting to /bin/systemctl stop  pulp_resource_manager.service

Stopping elasticsearch (via systemctl):  [  OK  ]
Redirecting to /bin/systemctl stop  httpd.service

Redirecting to /bin/systemctl stop  foreman-tasks.service

Success!
[root@qe-blade-12 ~]# service postgresql status
Redirecting to /bin/systemctl status  postgresql.service
postgresql.service - PostgreSQL database server
   Loaded: loaded (/etc/systemd/system/postgresql.service; enabled)
   Active: inactive (dead) since Tue 2015-11-10 16:30:27 EST; 57s ago
  Process: 7974 ExecStop=/usr/bin/pg_ctl stop -D ${PGDATA} -s -m fast (code=exited, status=0/SUCCESS)
  Process: 25059 ExecStart=/usr/bin/pg_ctl start -D ${PGDATA} -s -o -p ${PGPORT} -w -t 300 (code=exited, status=0/SUCCESS)
  Process: 25051 ExecStartPre=/usr/bin/postgresql-check-db-dir ${PGDATA} (code=exited, status=0/SUCCESS)
 Main PID: 25066 (code=exited, status=0/SUCCESS)
   CGroup: /system.slice/postgresql.service

Nov 09 10:55:10 qe-blade-12.idmqe.lab.eng.bos.redhat.com systemd[1]: Started PostgreSQL database server.
Nov 10 16:30:26 qe-blade-12.idmqe.lab.eng.bos.redhat.com systemd[1]: Stopping PostgreSQL database server...
Nov 10 16:30:27 qe-blade-12.idmqe.lab.eng.bos.redhat.com systemd[1]: Stopped PostgreSQL database server.

Comment 10 errata-xmlrpc 2016-07-27 09:13:48 UTC
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

https://access.redhat.com/errata/RHBA-2016:1501