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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
