upgrade issue - postgres

Bruno Wolff III bruno at wolff.to
Tue Jun 14 21:03:36 UTC 2005


On Tue, Jun 14, 2005 at 14:00:03 -0700,
  Craig White <craigwhite at azapple.com> wrote:
> I guess I am pretty dumb
> 
> Upgrade from FC-2 to FC-4
> 
> Postgresql 8 won't start:
> 
> # service 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.0.3/README.rpm-dist for more
> information.
> 
> That read me suggests that I need to do a database dump but of course, I
> don't have old version of database to dump with. I might be able to
> install on another computer. Isn't there an easier way?

Postgres upgrades between major versions is a pain. You need to do a dump
and restore running the old server (preferrably with a new client).

There has been talk about trying to do something about this on the postgres
lists, but I think it is unlikely to happen for 8.1.




More information about the fedora-list mailing list