>>[ pg_dump shows data corruption over local socket but not TCP ]
>
>
> That is really odd.
>
>
>>Anyway, we can live with that solution. But still I'd be curious to know
>>what is the problem with local connections. Is there a way to capture
>>traffic of local socket connections?
>
>
> No, not that I know of. You could modify libpq to dump everything it
> receives from the socket to a log file, and then compare the results
> from local socket and TCP cases.
>
> The whole thing is bizarre though. AFAICS it must represent a kernel
> bug. What is your platform exactly?
>
It's a RH7.1 with standard rpm kernel-2.4.2-2. The special thing is a
proprietary infortrend kernel modul rd124f necessary to access a
IFT-2101 raid.
Unfortunately Infortrend does not supply a modul for a more recent linux
distribution. The machine was originally intended to run Oracle on
Windows...
I will check whether the error occurs on an other machine with different
kernel but identical database and postgres version.
Regards, Stefan
--
-----------------------------
Dr. Stefan Holzheu
Tel.: 0921/55-5720
Fax.: 0921/55-5799
BITOeK Wiss. Sekretariat
Universitaet Bayreuth
D-95440 Bayreuth
-----------------------------