Thread: upgrading from 8.1.4 to 8.3.3

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

Em Thursday 28 August 2008 06:53:28 Joao Ferreira gmail escreveu:
> 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 ?

The dump & restore approach for major version upgrades is the appropriate,
correct and documented way to upgrade.

Check the docs and it is there.

--
Jorge Godoy      <jgodoy@gmail.com>

On Thu, 2008-08-28 at 10:53 +0100, Joao Ferreira gmail wrote:
> 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.

http://www.postgresql.org/docs/8.3/static/install-upgrading.html

Regards,
--
Devrim GÜNDÜZ, RHCE
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
                   http://www.gunduz.org