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      <[EMAIL PROTECTED]>


Attachment: signature.asc
Description: This is a digitally signed message part.

Reply via email to