| From: | yaptNO(at)technovellSPAM(dot)com |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | pg:8.0 -> 8.1 - COPY and UTF-8 error on restore. |
| Date: | 2005-12-30 17:28:52 |
| Message-ID: | toqar1tv3j9hn7hkie659smp6np14oagl1@4ax.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ubence Quevedo | 2005-12-30 21:52:08 | Correct way to set up Variables [Was - Simple Accumulating Number Loop?] |
| Previous Message | Steve Tucknott | 2005-12-30 15:11:00 | Re: pg_trigger permissions |