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»
That is, 2GB identifiers available.
No the problem is localized I can think o several ways to fix it:
1. Increment XID capacity. I dont think this will work because with time
I will reach the maximum value.
2. Reset XID counter?, I don't even know if this makes sense.
3. Do not make transactions?. In some cases I make thousands of SELECTS
and I know the data being used it not going to be modified.
If I close transactions the XID would decrement?... I do not really
understand why this counter keeps growing without decrementing.
I have read in http://www.thescripts.com/forum/thread173882.html that
with the command pg_resetxlog I can tweak the XID but I am not sure if
this is a safe way to fix the issue.
Thanks :)
Mario.
