upgrading from 8.1.4 to 8.3.3

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