Re: Upgrading database format on PostgreSQL 8.1 on FC6

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: arjun(at)greatgulfhomes(dot)com
Cc: Steve Crawford <scrawford(at)pinpointresearch(dot)com>, pgsql-novice(at)postgresql(dot)org
Subject: Re: Upgrading database format on PostgreSQL 8.1 on FC6
Date: 2008-08-01 22:16:59
Message-ID: 24089.1217629019@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Arjun Datta <arjun(at)greatgulfhomes(dot)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(at)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Frank Bax 2008-08-01 22:20:30 Re: Upgrading database format on PostgreSQL 8.1 on FC6
Previous Message Arjun Datta 2008-08-01 22:10:16 Re: Upgrading database format on PostgreSQL 8.1 on FC6