Bug 1165577

Summary: External Postgresql 8.4 is not already supported for the new installation of Sat5.7
Product: Red Hat Satellite 5 Reporter: Martin Korbel <mkorbel>
Component: Docs Installation GuideAssignee: Dan Macpherson <dmacpher>
Status: CLOSED CURRENTRELEASE QA Contact: Dan Macpherson <dmacpher>
Severity: high Docs Contact:
Priority: high    
Version: 570CC: cperry
Target Milestone: ---Keywords: ReleaseNotes
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2015-01-29 01:53:10 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:    
Bug Blocks: 1018166    

Description Martin Korbel 2014-11-19 09:16:29 UTC
Description of problem:
External Postgresql 8.x and older is not already supported for the new installation of Sat5.7.

Version-Release number of selected component (if applicable):
Satellite-5.7.0-RHEL6-re20141114.0

How reproducible:
100%

Steps to Reproduce:
1. When we try to install Sat5.7 with external Postgresql 8.4, we get this error message

> cat /var/log/rhn/populate_db.log
psql:/etc/sysconfig/rhn.1/postgres/deploy.sql:4: ERROR:  syntax error at or near "extension"
LINE 1: create extension dblink;


Actual results:


Expected results:
Make a record in documentation about this limitation.

Additional info:

Comment 1 Clifford Perry 2014-11-19 10:13:37 UTC
We'd like to have in the install guide to note that for External Databases we support PostgreSQL 9.2 or newer (along with the existing Oracle options). 

This change should also be mentioned within Release Notes for 5.7. 

Cliff

Comment 2 Clifford Perry 2014-11-19 11:02:16 UTC
So, this will be for NEW Installations. For a Customer already running External Oracle 8.4 with Satellite 5.6, they do not need to upgrade to postgreSQL 9.2 to upgrade to 5.7. They can run an upgraded (from 5.6) 5.7 with external postgreSQL 8.4. 

So, I'd expect the note/change in Release Note and/or Install Guide clarifies that this is for new installs of 5.7 while existing External 5.6 customers running postgreSQL 8.4 can upgrade to 5.7 without the requirement to upgrade the database version to 9.2 as well. 

Cliff