| From: | "Aaron Rouse" <pgsql(at)happyhacker(dot)com> |
|---|---|
| To: | "PostgreSQL" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Restoring data help |
| Date: | 2001-11-04 22:49:07 |
| Message-ID: | 016401c16582$eb486a70$0301a8c0@win2kpro |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
One of our boxes recently had a crash and the sys admins solution to get it
back up and going was to run a OS upgrade, the box is running RH 7.1 now.
The RH upgrade appears to have run a upgrade on the PGSQL database and now
the db will not start due to: "An old version of the database format was
found." From looking at the docs, it says to take the database to the
previous version via: "rpm -U --oldpackage" I will admit that I am not a
master of RPMs but my attempts at running this got me just errors:
[root(at)magicbox aaron]# rpm -U postgresql-7.0.2-21.i386.rpm
error: failed dependencies:
postgresql = 7.1.3 is needed by postgresql-server-7.1.3-2
[root(at)magicbox aaron]# rpm -U postgresql-server-7.0.2-21.i386.rpm
error: failed dependencies:
postgresql = 7.0.2 is needed by postgresql-server-7.0.2-21
Is there another way to go about changing the database to the new format
(PostgreSQL 7.1.3)?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Command Prompt, Inc. | 2001-11-04 23:30:47 | Re: Got error on CREATE TABLE AS (+Bug?) |
| Previous Message | Doug McNaught | 2001-11-04 21:09:14 | Re: Libpq coding assistance |