On Thu, Jun 07, 2007 at 02:32:09PM -0500, ARTEAGA Jose wrote: > I've looked at the pg_index table and we are currently at 15Mill > entries, which should be OK. After 2-3 days runtime I just get a > disconnect error from backend while doing an insert. After I restore the > DB and insert the same entries it runs fine. Following is the error I > get: Note: Version 7.0 *will* eat your data eventually. It has no protection against XID wraparound, you'll just start noticing data disappearing. From the documentation: Prior to PostgreSQL 7.2, the only defense against XID wraparound was to re-initdb at least every 4 billion transactions. Have a nice day, -- Martijn van Oosterhout <kleptog@xxxxxxxxx> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to litigate.
Attachment:
signature.asc
Description: Digital signature