| From: | Kelly Jones <kelly(dot)terry(dot)jones(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Upgrade db format without older version of PostgreSQL |
| Date: | 2009-09-29 16:18:50 |
| Message-ID: | 26face530909290918g2b155713l36be5351ecd14fce@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I recently upgraded PostgreSQL, and now this happens:
# /etc/init.d/postgresql start
An old version of the database format was found.
You need to upgrade the data format before using PostgreSQL.
See /usr/share/doc/postgresql-8.3.8/README.rpm-dist for more information.
Unfortunately, I upgraded due to a hardware failure, and can't
dump/undump, since I don't have the old PostgreSQL server anymore.
Can I upgrade the data format w/o installing Postgres 7.2 (my
"data/base/1/PG_VERSION" file says "7.2")?
If not, can Fedora 11's "yum" install Postgres 7.2 (so I can at least
do a clean install/uninstall and then re-install 8.3.8)?
--
We're just a Bunch Of Regular Guys, a collective group that's trying
to understand and assimilate technology. We feel that resistance to
new ideas and technology is unwise and ultimately futile.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Filip Rembiałkowski | 2009-09-29 16:29:18 | Re: Upgrade db format without older version of PostgreSQL |
| Previous Message | Tom Lane | 2009-09-29 16:17:51 | Re: bulk inserts |