Hello all,
I have a postgreSQL 8.0 installation running on a Windows XP
workstation. I have a database with a few tables and a lot of rows on
every table.
I am installing my new server on a Linux OpenSuse with PostgreSQL
8.1.1 and it is time to migrate my database to my new server.
I am doing a pg_dump and I am getting a "backup" file size of nearly 2
Gb.
Ok. I have ftp the file to my linux server and I am ready to "import"
(ala Oracle) data on the server, but I am getting this error:
(I have changed my clients name to protect their privacy. data99 is
the changed data)
..............
ERROR: invalid UTF-8 byte sequence detected near byte 0xa0
CONTEXT: COPY telefonos, line 28430, column apellido:
"data11Â data12Â data13"
ERROR: invalid UTF-8 byte sequence detected near byte 0xa0
CONTEXT: COPY telefonoserror, line 2076, column apellido:
"data21Â data22Â data23"
..............
What is my problem ?
How can I restore all info without problems ?
Greetings.