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:38:18 -0700
Message-ID: <4D8A300A.90105@gmail.com> (raw)
In-Reply-To: <AANLkTinWuwmcv9xNu9KFxCm_js6MB80O2X2rCckbz6-+@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>
<4D8A27DB.70702@gmail.com>
<AANLkTinWuwmcv9xNu9KFxCm_js6MB80O2X2rCckbz6-+@mail.gmail.com>
On 03/23/2011 10:33 AM, Martín Marqués wrote:
> El día 23 de marzo de 2011 14:03, Adrian Klaver
> <adrian.klaver@gmail.com> escribió:
>> On 03/23/2011 07:56 AM, Martín Marqués wrote:
>>>
>>>
>>> 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?
>
> How can I verify this? It's already dificult to manage the file, asi
> it has over 700Mb.
One way would be to dump only the table(s) that are causing the problem.
>
> The second error is very curious, as it looks like pg_dump changed 1
> for a 'q' in an integer field:
My guess is that it is combining data from two fields. In other words
the 'q' is the end of the previous field.
>
> psql:siprebi-bu.sql:2219245: ERROR: la sintaxis de entrada no es
> válida para integer: «q721695»
> CONTEXT: COPY objeto_datos_rep, línea 991894, columna codigo: «q721695»
>
> Looking at the dump file I see this:
>
> 1721693 657083 Eclairage... 5
> 1721694 657083 photometrie 5
> q721695 657084 Keitz, H. A. E. 2
> 1721696 657084 Ligth calculations and measurements... 5
> 1721697 657085 La Toison, M. 2
>
>> Does the data in the file look correct for the affected tables?
>> Are there any other errors being reported?
>
> Thats the first error. After that there are similar errores and others
> related to that register not gentting inserted (foreign keys that
> don't have there corresponding primary key).
>
--
Adrian Klaver
adrian.klaver@gmail.com
view thread (20+ messages) latest in thread
Message-ID: <4D8A300A.90105@gmail.com>
Permalink: ../4D8A300A.90105@gmail.com/
Also on: postgresql.org/message-id/4D8A300A.90105@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: <4D8A300A.90105@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