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

[Karsten Hilbert]

On Fri, Nov 15, 2013 at 01:32:29PM +0100, Hilbert, Sebastian wrote:

> 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.

Split the dump and restore steps.

Karsten
-- 
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346