From: | Francois Deliege <fdeliege(at)cs(dot)aau(dot)dk> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | moving data from windows to linux |
Date: | 2007-04-25 13:29:59 |
Message-ID: | 462F57D7.4020709@cs.aau.dk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi,
I am having problem importing data from a windows xp2 postgresql server
to a linux one.
On the windows server I did: pg_dumpall -U postgres > dumpall.sql
On the linux machine I did:
tr -d '\r' < /data/dumpall.sql | psql -U pgsql postgres
ERROR: invalid byte sequence for encoding "UTF8": 0x92
HINT: This error can also happen if the byte sequence does not match
the encoding expected by the server, which is controlled by
"client_encoding".
As adviced in
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000836&group_id=1000125
<http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000836&group_id=1000125>,
I changed the client_encoding in postgresql.conf and restarted the server.
I also changed it using \encoding in psql. But I get the same error.
What am I missing ?
Also, would a brutal copy of the base directory do the trick ?
Cheers,
Francois
Attachment | Content-Type | Size |
---|---|---|
fdeliege.vcf | text/x-vcard | 326 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | Phillip Smith | 2007-04-25 13:57:53 | Re: delete non-unique |
Previous Message | Frank Bax | 2007-04-25 13:01:12 | Re: Comparison of dates |