Обсуждение: postsgresql-dump not found in install
I just upgraded my redhat linux from 7.2 to 8.0. During that process postgresql 7.2.2 was installed on the system. According to the documentation i should run postgresql-dump. However, I can't find that program anywhere. Aside from the obvious of uninstalling 7.2, what can I do? Thanks
you mean: pg_dump ? C. Tony Ziolkowski wrote, On 12/29/2002 9:06 PM: > I just upgraded my redhat linux from 7.2 to 8.0. During that process > postgresql 7.2.2 was installed on the system. According to the > documentation i should run postgresql-dump. However, I can't find that > program anywhere. Aside from the obvious of uninstalling 7.2, what can I do? > > Thanks >
No I meant what i wrote. The section from README.rpm-dist is: To facilitate upgrading, the postgresql-dump utility has been provided. Look at the man page for postgresql-dump to see its usage. All executables to restore the immediately prior version of the PostgreSQL database are placed in the directory /usr/lib/pgsql/backup, and are accessed by the postgresql-dump script. The directory /usr/lib/pgsql/backup is owned by the postgres user -- you can use this directory to hold dump files and preserve directories. The basic sequence is: (as user postgres): postgresql-dump -t /var/lib/pgsql/backup/db.bak -p /var/lib/pgsql/backup/old -d (you can abort the ASCII dump with 'Q', as it uses more) Then, (as user root): service postgresql start (which will automatically create a new database structure) And finally, (as user postgres): psql -e template1 </var/lib/pgsql/backup/db.bak CoL wrote: > you mean: pg_dump ? > C. > > Tony Ziolkowski wrote, On 12/29/2002 9:06 PM: > >> I just upgraded my redhat linux from 7.2 to 8.0. During that process >> postgresql 7.2.2 was installed on the system. According to the >> documentation i should run postgresql-dump. However, I can't find that >> program anywhere. Aside from the obvious of uninstalling 7.2, what can >> I do? >> >> Thanks >> >
On Monday 30 December 2002 09:41, Tony Ziolkowski wrote: > To facilitate upgrading, the postgresql-dump utility has been provided. Red Hat shipped their packages for RH 8.0 without postgresql-dump. They didn't update their documentation. The postgresql-dump program is no longer included at all, and the documentation has been updated to reflect this fact in the 7.3.x RPMsets. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11
SO what's the solution? I have an unworking postgresql. -----Original Message----- From: Lamar Owen [mailto:lamar.owen@wgcr.org] Sent: December 31, 2002 8:25 PM To: Tony Ziolkowski; pgsql-admin@postgresql.org Subject: Re: [ADMIN] postsgresql-dump not found in install On Monday 30 December 2002 09:41, Tony Ziolkowski wrote: > To facilitate upgrading, the postgresql-dump utility has been provided. Red Hat shipped their packages for RH 8.0 without postgresql-dump. They didn't update their documentation. The postgresql-dump program is no longer included at all, and the documentation has been updated to reflect this fact in the 7.3.x RPMsets. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11