Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group