Upgrading from 7.1.2 to 7.2.1 on new server

From: "Jean Huveneers" <j(dot)huveneers(at)farcourier(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Upgrading from 7.1.2 to 7.2.1 on new server
Date: 2002-04-21 13:45:02
Message-ID: 71E201BE5E881C46811BA160694C5FCB014F97@fs1000.farcourier.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I've been using postgres 7.1.3 in production with a couple of unicode
databases.
Last week we bought a new server, i've installed RedHat Linux 7.2 on it
with postgres SQL 7.2.1.

Now, went i to move the data ('pg_dumpall > data_dump' on the old
server, psql template1 < data_dump data on the new server) i get an
error. psql continous but, same tables on the new server are not filled.
the error has something to do with 'illage unicode character sequence'.

Can somebody please give me some advise on how i fix these errors? or is
there another way to upgrade than via pg_dump?

Regards,

Jean Huveneers

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Nick Fankhauser 2002-04-21 13:52:06 Re: JDBC and servlet...
Previous Message Gunnar 2002-04-21 07:35:17 Connection problem