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@xxxxxxxxx>
Attachment:
signature.asc
Description: This is a digitally signed message part.
