From: | Kevin Kempter <kevin(at)kevinkempterllc(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | pg_restore errors |
Date: | 2008-01-22 01:06:57 |
Message-ID: | 200801211806.57989.kevin@kevinkempterllc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi List;
Trying to restore a pg_dump I get this:
pg_restore: ERROR: invalid byte sequence for encoding "UTF8": 0xae
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".
CONTEXT: COPY imm_lookup, line 2
pg_restore: [archiver (db)] error returned by PQendcopy: ERROR: invalid byte
sequence for encoding "UTF8": 0xae
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".
CONTEXT: COPY imm_lookup, line 2
This is a dump file that was handed to me from a client. I don't know anything
about what the dump flags were or what the db encoding was. Is there a way to
find out (I'm assuming this is an encoding mis-match) from the dump file.
I did do a pg_restore -l and got this:
<snip>
;
; Archive created at Wed Nov 28 21:04:49 2007
; dbname: practice
; TOC Entries: 867
; Compression: -1
; Dump Version: 1.10-0
; Format: CUSTOM
; Integer: 4 bytes
; Offset: 4 bytes
; Dumped from database version: 8.1.9
; Dumped by pg_dump version: 8.1.4
;
;
; Selected TOC Entries:
;
5; 2615 2200 SCHEMA - public postgres
2911; 0 0 COMMENT - SCHEMA public postgres
2912; 0 0 ACL - public postgres
589; 2612 43134 PROCEDURAL LANGUAGE - plpgsql
14; 1255 43135 FUNCTION public dtos(date) postgres
27; 1255 43136 FUNCTION public get_session_alta_user() postgres
15; 1255 43137 FUNCTION public plpgsql_call_handler() postgres
16; 1255 43138 FUNCTION public plpgsql_validator(oid) postgres
23; 1255 43139 FUNCTION public process_appointment_audit() postgres
24; 1255 43140 FUNCTION public process_billing_audit() postgres
25; 1255 43141 FUNCTION public process_billing_detail_audit() postgres
26; 1255 43142 FUNCTION public process_patient_audit() postgres
1524; 1259 43146 TABLE public address postgres
2913; 0 0 SEQUENCE SET public address_rec_no_seq postgres
</snip>
Any thoughts?
Thanks in advance..
/Kevin
From | Date | Subject | |
---|---|---|---|
Next Message | Phillip Smith | 2008-01-22 01:20:18 | Re: pg_restore errors |
Previous Message | Guillermo Arias | 2008-01-21 23:49:55 | how to create a limited user |