Re: Tried to upgrade from 7.1.3 to 7.2 --Fatal Error - Mailing list pgsql-novice

From Oliver Elphick
Subject Re: Tried to upgrade from 7.1.3 to 7.2 --Fatal Error
Date
Msg-id 1014666624.5760.2.camel@linda
Whole thread Raw
In response to Tried to upgrade from 7.1.3 to 7.2 --Fatal Error  (Pam Wampler <Pam_Wampler@taylorwhite.com>)
List pgsql-novice
On Mon, 2002-02-25 at 15:27, Pam Wampler wrote:
> I am new to postgresql & tried to upgrade from 7.1.3 to 7.2  -- when I did
> pg_ctl start I get this error
>
> FATAL 1:  The data directory was initialized by PostgreSQL version 7.1,
> which is not compatible with this version 7.2.

Unfortunately, you haven't fully read the installation instructions.

The database formats fo 7.1.3 and 7.2 are not compatible.  You need to
reinstall 7.1.3 and use pg_dumpall to make a dump of your database(s):

su - postgres
pg_dumpall > your_dump

Then install7.2 again, run initdb to create a new database structure and
then "psql -d template1  < your_dump" to restore your data.

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C

     "Peace I leave with you, my peace I give unto you; not
      as the world giveth, give I unto you. Let not your
      heart be troubled, neither let it be afraid."
                                John 14:27


pgsql-novice by date:

Previous
From: Richard Ray
Date:
Subject: Mailing list help
Next
From: Oliver Elphick
Date:
Subject: Re: Major newbie