Postgres Pro
Downloads
Home   >   mailing lists

upgrading from 8.1.4 to 8.3.3 - Mailing list pgsql-general

From Joao Ferreira gmail
Subject upgrading from 8.1.4 to 8.3.3
Date
Msg-id 1219917208.6439.15.camel@jmf-ubuntu
Whole thread Raw
Responses Re: upgrading from 8.1.4 to 8.3.3  (Jorge Godoy <jgodoy@gmail.com>)
Re: upgrading from 8.1.4 to 8.3.3  (Devrim GÜNDÜZ <devrim@gunduz.org>)
List pgsql-general
Tree view 
Hello all,

I'm getting this error after installing pg-8.3.3 on a test system which
had 8.1.4

shell> su postgres -c "/usr/bin/postmaster -D /var/pgsql/data"
FATAL:  database files are incompatible with server
DETAIL:  The data directory was initialized by PostgreSQL version 8.1,
which is not compatible with this version 8.3.3.


I guess I should get a pg_dumpall before upgrading and put the data back
after the upgrade.

Is this correct ?

Is there a more apropriate approach ?

thanks
joao

pgsql-general by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: Slow PG after upgrade to 8.2.9!!
Next
From: Jorge Godoy
Date:
Subject: Re: upgrading from 8.1.4 to 8.3.3