Re: pg_dump problems - Mailing list pgsql-general

From Martín Marqués
Subject Re: pg_dump problems
Date
Msg-id AANLkTimzAn5O5VUh9awMEFDvHKUMKJeGEwa5pOv6=KQK@mail.gmail.com
Whole thread Raw
In response to Re: pg_dump problems  (Vick Khera <vivek@khera.org>)
Responses Re: pg_dump problems  (Martín Marqués <martin.marques@gmail.com>)
List pgsql-general
2011/3/23 Vick Khera <vivek@khera.org>:
> 2011/3/23 Martín Marqués <martin.marques@gmail.com>:
>> The second error is very curious, as it looks like pg_dump changed 1
>> for a 'q' in an integer 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»
>>
>
> That's a single-bit error.  I'm voting hardware problems.  Does your
> memory have ECC?  How reliable is your disk?
>

The production server is a Compaq Prolaint, with ECC memory and RAID
by hardware.

How can I discard, or affirm that we are dealing with hardware problems?

--
Martín Marqués
select 'martin.marques' || '@' || 'gmail.com'
DBA, Programador, Administrador

pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: RAID 1 - drive failed - very slow queries even after drive replaced
Next
From: Emi Lu
Date:
Subject: pdf saving into DB vs. saving file location ?