[GENERAL] Database corruption with Postgre 7.4.2 on FreeBSD 6.1?

2006-07-26 Thread aurora
Hello, We are stressing testing our application. It adds and deletes a lot of rows. Within 24 hours we ran into some sort of database corruption problem. We got this error when trying to insert into the users table. ERROR XX001: invalid page header in block 2552 of relation "users_name_l

Re: [GENERAL] Database corruption with Postgre 7.4.2 on FreeBSD 6.1?

2006-07-26 Thread aurora
From your experience do you expect the database would run into this from time to time that requires DBA's interventions? Is so it would become a problem for our customers because our product is a standalone system. We don't intend to expose the Postgre database underneath. wy Try doing a R