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

[Sebastian Hilbert]

Am Freitag, 15. November 2013, 14:34:58 schrieb 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.
> 
I did. Same thing.

Will try to get more information.

Sebastian