| From: | Martín Marqués <martin(dot)marques(at)gmail(dot)com> |
|---|---|
| To: | Vick Khera <vivek(at)khera(dot)org> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: pg_dump problems |
| Date: | 2011-03-23 19:28:02 |
| Message-ID: | AANLkTimzAn5O5VUh9awMEFDvHKUMKJeGEwa5pOv6=KQK@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
2011/3/23 Vick Khera <vivek(at)khera(dot)org>:
> 2011/3/23 Martín Marqués <martin(dot)marques(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Emi Lu | 2011-03-23 20:01:55 | pdf saving into DB vs. saving file location ? |
| Previous Message | Andrew Sullivan | 2011-03-23 19:17:33 | Re: RAID 1 - drive failed - very slow queries even after drive replaced |