[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Gnumed-devel] Upgrading cluster from PG 8.4 to PG 9.2 on Windows
From: |
Sebastian Hilbert |
Subject: |
Re: [Gnumed-devel] Upgrading cluster from PG 8.4 to PG 9.2 on Windows |
Date: |
Fri, 15 Nov 2013 15:04:51 +0100 |
User-agent: |
KMail/4.11.2 (Linux/3.11.0-13-generic; KDE/4.11.2; i686; ; ) |
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