agora inbox for pgsql-general@postgresql.org
help / color / mirror / Atom feedFrom: Adrian Klaver <adrian.klaver@gmail.com>
To: Martín Marqués <martin.marques@gmail.com>
Cc: pgsql-general@postgresql.org, Vick Khera <vivek@khera.org>
Subject: Re: pg_dump problems
Date: Wed, 23 Mar 2011 10:03:23 -0700
Message-ID: <4D8A27DB.70702@gmail.com> (raw)
In-Reply-To: <AANLkTimhyrtNEGJz_+0u+kSkUy9+da-cFkJ=ZgekU2jK@mail.gmail.com>
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>
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
view thread (20+ messages) latest in thread
Message-ID: <4D8A27DB.70702@gmail.com>
Permalink: ../4D8A27DB.70702@gmail.com/
Also on: postgresql.org/message-id/4D8A27DB.70702@gmail.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-general@postgresql.org
Cc: adrian.klaver@gmail.com, martin.marques@gmail.com, vivek@khera.org
Subject: Re: pg_dump problems
In-Reply-To: <4D8A27DB.70702@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox