[ 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 -----------------------------
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
