[GENERAL] Corruption of files in PostgreSQL

2007-05-30 Thread Paolo Bizzarri
Hi everyone, my name is Paolo Bizzarri and I am a developer of PAFlow, an document tracking and management system for public administrations. We use postgres as a backend, and we are experimenting some corruption problems on openoffice files. As our application is rather complex (it includes

Re: [GENERAL] Corruption of files in PostgreSQL

2007-05-30 Thread Paolo Bizzarri
On 5/30/07, Richard Huxton <[EMAIL PROTECTED]> wrote: Paolo Bizzarri wrote: > We use postgres as a backend, and we are experimenting some corruption > problems on openoffice files. 1. How are you storing these files? Files are stored as large objects. They are written with an lo_w

[GENERAL] Question about corruption about openoffice file

2007-05-30 Thread Paolo Bizzarri
Hi everyone, my name is Paolo Bizzarri and I am a developer of PAFlow, an document tracking and management system for public administrations. We use postgres as a backend, and we are experimenting some corruption problems on openoffice files. As our application is rather complex (it includes

Re: [GENERAL] Question about corruption about openoffice file

2007-05-30 Thread Paolo Bizzarri
On 5/30/07, Matthew T. O'Connor <[EMAIL PROTECTED]> wrote: Paolo Bizzarri wrote: > my name is Paolo Bizzarri and I am a developer of PAFlow, an document > tracking and management system for public administrations. > > We use postgres as a backend, and we are experi

Re: [GENERAL] Corruption of files in PostgreSQL

2007-06-01 Thread Paolo Bizzarri
DB; - we give the file to the user, and he can modify at its wish the file; - we store back the modified file on the DB; - the last two points can happen several times. Any hint? Best regards. Paolo Bizzarri Icube S.r.l. On 5/30/07, Purusothaman A <[EMAIL PROTECTED]> wrote: Paolo Bi

Re: [GENERAL] Corruption of files in PostgreSQL

2007-06-01 Thread Paolo Bizzarri
Hi Tom, as explained above, the problem seems quite random. So I need to understand what we have to check. Best regards. Paolo Bizzarri Icube S.r.l. On 6/2/07, Tom Lane <[EMAIL PROTECTED]> wrote: "Paolo Bizzarri" <[EMAIL PROTECTED]> writes: > Any hint? Please pr

Re: [GENERAL] Corruption of files in PostgreSQL

2007-06-02 Thread Paolo Bizzarri
On 6/2/07, Tom Lane <[EMAIL PROTECTED]> wrote: "Paolo Bizzarri" <[EMAIL PROTECTED]> writes: > On 6/2/07, Tom Lane <[EMAIL PROTECTED]> wrote: >> Please provide a reproducible test case ... > as explained above, the problem seems quite random. So I need to

Re: [GENERAL] Corruption of files in PostgreSQL

2007-06-05 Thread Paolo Bizzarri
Hi Scott, in fact, we were using a 2.6.12 kernel. Can this be a problem? Best regards. Paolo Bizzarri On 6/4/07, Scott Marlowe <[EMAIL PROTECTED]> wrote: Paolo Bizzarri wrote: > On 6/2/07, Tom Lane <[EMAIL PROTECTED]> wrote: >> "Paolo Bizzarri" <[EMAIL PROTE

Re: [GENERAL] Corruption of files in PostgreSQL

2007-06-06 Thread Paolo Bizzarri
On 6/5/07, Scott Marlowe <[EMAIL PROTECTED]> wrote: Greg Smith wrote: > On Tue, 5 Jun 2007, Paolo Bizzarri wrote: > >> On 6/4/07, Scott Marlowe <[EMAIL PROTECTED]> wrote: >>> http://lwn.net/Articles/215868/ >>> documents a bug in the 2.6 linux kernel