Search Postgresql Archives

upgrading from 8.1.4 to 8.3.3

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux