Re: pg_dump problems

Поиск
Список
Период
Сортировка
От Martín Marqués
Тема Re: pg_dump problems
Дата
Msg-id AANLkTimzAn5O5VUh9awMEFDvHKUMKJeGEwa5pOv6=KQK@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pg_dump problems  (Vick Khera <vivek@khera.org>)
Ответы Re: pg_dump problems  (Martín Marqués <martin.marques@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Andrew Sullivan
Дата:
Сообщение: Re: RAID 1 - drive failed - very slow queries even after drive replaced
Следующее
От: Emi Lu
Дата:
Сообщение: pdf saving into DB vs. saving file location ?