Re: PostgreSQL XID exceeded crash.

Mario Lopez wrote:
> Hi!,
>
> I am having an XID issue with PostgreSQL, while doing a pg_restore from
> a 200MB saved database I get a server crash, searching through the debug
> messages I have found that PostgreSQL crashes due to a exausted XID
> resource with a message that looks this way (sorry for the Spanish log)
>
> UBICACIÓN: StartupXLOG, xlog.c:4820
> LOG: 00000: el límite para el reciclaje de ID de transacciones es
> 2147484146, limitado por base de datos «postgres»

This is not a problem. If you see a crash, the message is elsewhere --
the message should start with ERROR, FATAL or PANIC. LOG is normal
operation. I suggest you look at the log more closely.

Maybe the error is the line above; LOCATION lines (UBICACIÓN) are
located just below the log entry they are annotating.

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support