Bug 1165577 - External Postgresql 8.4 is not already supported for the new installation of Sat5.7
Summary: External Postgresql 8.4 is not already supported for the new installation of ...
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Red Hat Satellite 5
Classification: Red Hat
Component: Docs Installation Guide
Version: 570
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: ---
Assignee: Dan Macpherson
QA Contact: Dan Macpherson
URL:
Whiteboard:
Depends On:
Blocks: sat-docs
TreeView+ depends on / blocked
 
Reported: 2014-11-19 09:16 UTC by Martin Korbel
Modified: 2019-02-15 13:52 UTC (History)
1 user (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2015-01-29 01:53:10 UTC
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)

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


Note You need to log in before you can comment on or make changes to this bug.