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