Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id CC0892E01E0 for ; Sun, 16 Dec 2007 16:05:59 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 61902-10 for ; Sun, 16 Dec 2007 16:05:50 -0400 (AST) Received: from mu-out-0910.google.com (mu-out-0910.google.com [209.85.134.189]) by postgresql.org (Postfix) with ESMTP id 52CAE2E01DB for ; Sun, 16 Dec 2007 16:05:52 -0400 (AST) Received: by mu-out-0910.google.com with SMTP id i10so2888128mue.3 for ; Sun, 16 Dec 2007 12:05:50 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; bh=anMbRcEz2vEAptWLxziWkEvdZUACMNDfHE7FgG/T0bw=; b=AFdFWW2f3dTXYr5jDvHakbO/SL8XTC28c3Rc59vlXaDg3bj2SS5gzK6Zf8SifWVfSTue6Z+zY6YmD0o0cFsclXFIehljinGhzK/ENayw0oVpdBwq23ABO+er7N/YhfJQLGGAJULZMQynpirHOKU0AINUxCoTsXKfbl8jZixUcaU= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=jcKBgdQCYyvBmP9BNzhN9jokiv1PkhISMFRE1Ep+WCOpoNp7tnDl81r0D4l2UU+YC42qWbtYa6rZavyhXFpIbyWlKppnL+tzya0e7gp/OdJ2h/fkgWgmk5+mnn+jaWm43w0Bsj2K4Z9wVy3Bsgsg1XPaWfL6SyP1vCqQdCdV6jU= Received: by 10.78.138.14 with SMTP id l14mr2084389hud.57.1197835550309; Sun, 16 Dec 2007 12:05:50 -0800 (PST) Received: by 10.78.151.9 with HTTP; Sun, 16 Dec 2007 12:05:50 -0800 (PST) Message-ID: Date: Mon, 17 Dec 2007 01:05:50 +0500 From: "Usama Dar" To: "Kevin Kempter" Subject: Re: pg_restore error Cc: pgsql-admin@postgresql.org In-Reply-To: <200712131006.23925.kevin@kevinkempterllc.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_5709_24403747.1197835550294" References: <200712131006.23925.kevin@kevinkempterllc.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/130 X-Sequence-Number: 27647 ------=_Part_5709_24403747.1197835550294 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline On Dec 13, 2007 10:06 PM, Kevin Kempter wrote: > Hi list; > > We're seeing this error whern trying to restore a pg_dump file: > > > --------------------------------------------------------------------------------------------------------- > pg_restore: ERROR: invalid byte sequence for encoding "UTF8": 0x9f > CONTEXT: > COPY log_customer_api, line 4551 pg_restore: [archiver (db)] error > returned > by PQendcopy: ERROR: invalid byte sequence for encoding "UTF8": 0x9f > CONTEXT: COPY log_customer_api, line 4551 pg_restore: *** aborted because > of > error > > --------------------------------------------------------------------------------------------------------- > > > Any thoughts? > > Which version are you trying to restore into? Which version did you dump from? -- Usama Munir Dar http://linkedin.com/in/usamadar Consultant Architect Cell:+92 321 5020666 Skype: usamadar ------=_Part_5709_24403747.1197835550294 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline

On Dec 13, 2007 10:06 PM, Kevin Kempter <kevin@kevinkempterllc.com> wrote:
Hi list;

We're seeing this error whern trying to restore a pg_dump file:

---------------------------------------------------------------------------------------------------------
pg_restore: ERROR:  invalid byte sequence for encoding "UTF8": 0x9f CONTEXT:
COPY log_customer_api, line 4551 pg_restore: [archiver (db)] error returned
by PQendcopy: ERROR:  invalid byte sequence for encoding "UTF8": 0x9f
CONTEXT:  COPY log_customer_api, line 4551 pg_restore: *** aborted because of
error
---------------------------------------------------------------------------------------------------------


Any thoughts?


Which version are you trying to restore into? Which version did you dump from?

--
Usama Munir Dar http://linkedin.com/in/usamadar
Consultant Architect
Cell:+92 321 5020666
Skype: usamadar
------=_Part_5709_24403747.1197835550294--