[Gnumed-devel] Upgrading cluster from PG 8.4 to PG 9.2 on Windows

[Sebastian Hilbert]

Hi,

 

I have PG 8.4 running on port 5432 and PG 9.2 running on port 9433

 

Jim suggested this:

http://fuzzytolerance.info/blog/postgresql-upgrade-tip/

 

I ran this command

 

pg_dumpall -p 5432 -U postgres | psql -d postgres -p 5433 -U postgres

 

It did dumpall apparently without any error but was unable to restore it to the other cluster.

 

I get loads of errors like this:

psql:c:/pg84.sql:596820: ungültige Anweisung \N

psql:c:/pg84.sql:596821: ungültige Anweisung \N

psql:c:/pg84.sql:596822: ungültige Anweisung \N

psql:c:/pg84.sql:596823: ungültige Anweisung \N

psql:c:/pg84.sql:596824: ungültige Anweisung \N

psql:c:/pg84.sql:596825: ungültige Anweisung \N

psql:c:/pg84.sql:596826: ungültige Anweisung \N

psql:c:/pg84.sql:596827: ungültige Anweisung \N

psql:c:/pg84.sql:596828: ungültige Anweisung \N

psql:c:/pg84.sql:596829: ungültige Anweisung \N

 

I assume there is a problem the line encoding.

 

Any help would be appreciated.

 

Sebastian