pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Kevin Kempter <kevin@kevinkempterllc.com>
To: pgsql-admin@postgresql.org
Subject: pg_restore errors
Date: Mon, 21 Jan 2008 18:06:57 -0700
Message-ID: <200801211806.57989.kevin@kevinkempterllc.com> (raw)

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



view thread (3+ messages)  latest in thread

Message-ID: <200801211806.57989.kevin@kevinkempterllc.com>
Permalink:  ../200801211806.57989.kevin@kevinkempterllc.com/
Also on:    postgresql.org/message-id/200801211806.57989.kevin@kevinkempterllc.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: kevin@kevinkempterllc.com
  Subject: Re: pg_restore errors
  In-Reply-To: <200801211806.57989.kevin@kevinkempterllc.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox