Red Hat Bugzilla – Bug 72774
postgresql-dump command is missing
Last modified: 2007-04-18 12:46:05 EDT
From Bugzilla Helper:
User-Agent: Mozilla/4.79 [en] (Windows NT 5.0; U)
Description of problem:
/usr/share/doc/postgresql-7.2.1/README.rpm-dist describes upgrading the database after the RPM install using postgresql-dump. But this command is not in the
Version-Release number of selected component (if applicable):
Steps to Reproduce:
1. rpm -Uvh postgres-*
2. postgresql-dump -t /var/lib/pgsql/backups/db.bak -p /var/lib/pgsql/backups/old -d
Actual Results: bash: postgresql-dump: command not found
Expected Results: postgresql-dump should create a backup of the old database
The release notes said to dump the database before upgrade. The script was
broken, and is therefore not included.
In that case README.rpm-dist should be modified to document this correctly or deleted. If it is deleted, the initscript will need to be modified not to refer to it if the
wrong database version is present.
It is mentioned in README.rpm-dist:
NOTE: This program is not included in the packages distributed with
Red Hat Linux. The releasenotes specifies a dump before a system
That's OK once you figure out that "this program" refers to the postgresql-dump program which is not mentioned by name until 5 paragraphs later.
I'd prefer something like this:
NOTE: You cannot use the upgrade process described below on Red Hat Linux. The postgresql-dump program used in the first step is not included in the packages
distributed with Red Hat Linux because it is broken. <Describe how it is broken and why you can't fix it.> The releasenotes document specifies that you must dump
the database before performing a system upgrade.