Re: Upgrading database format on PostgreSQL 8.1 on FC6 - Mailing list pgsql-novice

Arjun Datta <arjun@greatgulfhomes.com> writes:
> I have a PG dump (using pg_dumpall) from a PostgreSQL 7.3.4 server on
> Redhat 7.2 that I am trying to restore.

> But on the newer machine (I cannot verify if postgres has ever been run
> on it or if it did when last), even before I try to restore, I notice
> that on startup I get the following error.

> [root@devdb3 8.1]# service postgresql start

> An old version of the database format was found.
> You need to upgrade the data format before using PostgreSQL.

If you know that there is no useful data on the machine, just rm -rf
/var/lib/pgsql/data (or wherever PGDATA is ... it's a good idea to
look into the start script to be sure).

            regards, tom lane