gnumed-devel
[Top][All Lists]
Advanced

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

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


From: Sebastian Hilbert
Subject: [Gnumed-devel] Upgrading cluster from PG 8.4 to PG 9.2 on Windows
Date: Fri, 15 Nov 2013 13:32:29 +0100
User-agent: KMail/4.11.2 (Linux/3.11.0-13-generic; KDE/4.11.2; i686; ; )

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


reply via email to

[Prev in Thread] Current Thread [Next in Thread]