Bug 1165057
Summary: | db-control fails to do online-backup due to: pg_dump: server version: 9.2.8; pg_dump version: 8.4.20 | ||
---|---|---|---|
Product: | Red Hat Satellite 5 | Reporter: | Jan Hutař <jhutar> |
Component: | Client | Assignee: | Michael Mráka <mmraka> |
Status: | CLOSED CURRENTRELEASE | QA Contact: | Pavel Studeník <pstudeni> |
Severity: | high | Docs Contact: | |
Priority: | high | ||
Version: | 570 | CC: | cperry, pstudeni |
Target Milestone: | --- | Keywords: | Regression |
Target Release: | --- | ||
Hardware: | Unspecified | ||
OS: | Unspecified | ||
Whiteboard: | |||
Fixed In Version: | spacewalk-web-2.3.2-19-sat | Doc Type: | Bug Fix |
Doc Text: | Story Points: | --- | |
Clone Of: | Environment: | ||
Last Closed: | 2015-01-13 10:26:28 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: | 1127215 |
Description
Jan Hutař
2014-11-18 08:53:12 UTC
/usr/bin/pg_dump is provided by postgresql-8.4.20-1.el6_5.x86_64, which explains why it is the 8.4 version. postgresql92-postgresql-9.2.8-2.el6.x86_64 installs its own version at /opt/rh/postgresql92/root/usr/bin/pg_dump, probably we need to update db-controll to look for the PG9.2 version of tools first? If someone more familiar with Perl wants to take this in the morning then feel free, otherwise I'll start working on it when I get in. I think that the references to /usr/bin/pg_dump and /usr/bin/pg_restore in BackupCommands.pm need to be updated to have a prefix of "/opt/rh/postgresql92/root" if we're on a postgresql92 database. Fixed in spacewalk master by commit 5bd3cbfeea81543f25a9749309017d58b83bbe19 1165057 - use scl wrapper for postgresql92 binaries commit 74dbe3a6bb88f29e7cef6fa702e9daab77fde708 1165057 - use correct path for postgresql92 Backported to SATELLITE-5.7 as commit ce26269c4e171772d798546ac78d645f299efb54 1165057 - use scl wrapper for postgresql92 binaries commit 8e905a5b76fc15f6df642be4edbc626dd7885464 1165057 - use correct path for postgresql92 verified with spacewalk-dobby-2.3.2-19.el6sat.noarch
>> db-control online-backup /tmp/online-backup
Backing up to file /tmp/online-backup.
pg_dump: reading schemas
pg_dump: reading user-defined tables
pg_dump: reading extensions
....
pg_dump: dumping contents of table web_user_prefix
pg_dump: dumping contents of table web_user_site_info
pg_dump: dumping contents of table web_user_site_type
Backup complete.
With the release of Red Hat Satellite 5.7 on January 12th 2015 this bug is being moved to a Closed Current Release state. The Satellite 5.7 GA Errata: - https://rhn.redhat.com/errata/RHSA-2015-0033.html Satellite 5.7 Release Notes: - https://access.redhat.com/documentation/en-US/Red_Hat_Satellite/5.7/html-single/Release_Notes/index.html Satellite Customer Portal Blog announcement for release: - https://access.redhat.com/blogs/1169563/posts/1315743 Cliff NOTE: This bug has not been re-verified (moved to RELEASE_PENDING) prior to release. We assume that the bug has indeed been fixed and not regressed since we initially verified it. Please re-open in the future if needed. |