Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id 5ECC51337BB4
	for <pgsql-general-postgresql.org@mail.postgresql.org>;
	Wed, 23 Mar 2011 14:03:37 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024)
	with ESMTP id 14010-05
	for <pgsql-general-postgresql.org@mail.postgresql.org>;
	Wed, 23 Mar 2011 17:03:27 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-pv0-f174.google.com (mail-pv0-f174.google.com
	[74.125.83.174])
	by mail.postgresql.org (Postfix) with ESMTP id AA6171337BA6
	for <pgsql-general@postgresql.org>;
	Wed, 23 Mar 2011 14:03:26 -0300 (ADT)
Received: by pvg12 with SMTP id 12so1053351pvg.19
	for <pgsql-general@postgresql.org>;
	Wed, 23 Mar 2011 10:03:25 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:message-id:date:from:user-agent:mime-version:to
	:cc:subject:references:in-reply-to:content-type
	:content-transfer-encoding;
	bh=etDoEE1DBRsy+IMXvUbRPJtOr/TCYvrvraImPOIqfKc=;
	b=euvJHp9N4CbtUGtFdWuhfFeTX9B+SDFfIo1P7TkqhFDglM+8dWgoLGc/R6R0KJYKzX
	tsyFNAn8YInm8IyLn9hGgEoZyHBdY5XtWX+Iw5DgtsUOyLTiBFc2cwplqsiYWb1y6iZx
	ztq0CmljCrU3b8BA9f8GaIK2RbfVtsxujg7xc=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:user-agent:mime-version:to:cc:subject
	:references:in-reply-to:content-type:content-transfer-encoding;
	b=vAjvsnKnHde/PeQLeRBxKRAuOPk34yeI9miDxGI4ZqoBngNBq2LQ13oX7uWf9BdGnz
	QEzL9weN2rQSFJwEiXHhtIw6+FXK1Qv2nYHm4Y4JcE5IxWXreAgIJDs81CLANIS8eAyJ
	M6avJ+Tn494CO8GiNfHqk8mTng69yzQU6ALE4=
Received: by 10.142.5.23 with SMTP id 23mr5134567wfe.249.1300899805860;
	Wed, 23 Mar 2011 10:03:25 -0700 (PDT)
Received: from [192.168.0.109] (c-24-17-179-185.hsd1.wa.comcast.net
	[24.17.179.185])
	by mx.google.com with ESMTPS id 25sm10297676wfb.22.2011.03.23.10.03.24
	(version=SSLv3 cipher=OTHER); Wed, 23 Mar 2011 10:03:25 -0700 (PDT)
Message-ID: <4D8A27DB.70702@gmail.com>
Date: Wed, 23 Mar 2011 10:03:23 -0700
From: Adrian Klaver <adrian.klaver@gmail.com>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US;
	rv:1.9.2.15) Gecko/20110303 Thunderbird/3.1.9
MIME-Version: 1.0
To: =?UTF-8?B?TWFydMOtbiBNYXJxdcOpcw==?= <martin.marques@gmail.com>
CC: pgsql-general@postgresql.org, Vick Khera <vivek@khera.org>
Subject: Re: pg_dump problems
References: <AANLkTinjOO5_6xupQ=UakBdUnU2NKcgJG8b_YzuoZejS@mail.gmail.com>
	<AANLkTi=aUNEsaacooaTcXV1YEY8G_ATmrTJGG1u5Uk74@mail.gmail.com>
	<AANLkTi=cRUPnFT4Jb-o1MpU+7SomrPtbR=jxSy4=x_SA@mail.gmail.com>
	<201103230718.40361.adrian.klaver@gmail.com>
	<AANLkTimhyrtNEGJz_+0u+kSkUy9+da-cFkJ=ZgekU2jK@mail.gmail.com>
In-Reply-To: <AANLkTimhyrtNEGJz_+0u+kSkUy9+da-cFkJ=ZgekU2jK@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.899 tagged_above=-5 required=5 tests=BAYES_00=-1.9,
	FREEMAIL_FROM=0.001
X-Spam-Level: 
X-Archive-Number: 201103/828
X-Sequence-Number: 174089

On 03/23/2011 07:56 AM, Martín Marqués wrote:
> El día 23 de marzo de 2011 11:18, Adrian Klaver
> <adrian.klaver@gmail.com>  escribió:
>> On Wednesday, March 23, 2011 6:57:35 am Martín Marqués wrote:
>>
>>> Now I'm getting weirder things. I did a pg_dump with -d option and the
>>
>>> dump adds strange caracters:
>>
>> As previously stated try using the 8.4 version of pg_dump to dump the 8.3
>> database. FYI in 8.4+ there is no -d option anymore, it has become --inserts
>> to reduce confusion with other commands where -d specified the database.
>
>
> Ok, did a remote dump (from the development server which has pg 8.4)
> and I got a similar error:
>
> psql:siprebi-bu.sql:27374: ERROR:  sintaxis de entrada no
> v<C3><A1>lida para tipo bytea
> CONTEXT:  COPY novedades_fotos, l<C3><AD>nea 273, columna foto:
> <C2><AB>\377\330\377\340\000\020JFIF\000\001\001\001\000`\000`\000\000\377\341<\310Exif\000\000II
> *\000\010\0...<C2><BB>
> psql:siprebi-bu.sql:3477848: ERROR:  la sintaxis de entrada no es
> v<C3><A1>lida para integer:<C2><AB>q43116<C2><BB>
> CONTEXT:  COPY objetos, l<C3><AD>nea 99185, columna codigo:
> <C2><AB>q43116<C2><BB>
>

So you are feeding a plain text dump to psql correct?
Does the data in the file look correct for the affected tables?
Are there any other errors being reported?


-- 
Adrian Klaver
adrian.klaver@gmail.com