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@svana.org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.