g.hintermayer@inode.at wrote:
> On Jun 18, 10:44 pm, alvhe...@commandprompt.com (Alvaro Herrera)
> wrote:
>
> >
> > Please check "MultiXact" id consumption. Do you mean that your server
> > has crashed?
> >
> How do I check MilitXact id consumption ? Is it "Latest checkpoint's
> NextXID:" in the output of pg_controldata ?
No, it is these lines:
> Latest checkpoint's NextMultiXactId: 1
> Latest checkpoint's NextMultiOffset: 0
Which are the initial values. This means that you haven't use
MultiXacts at all! The message about failing to truncate the dir is
certainly a bug, and certainly harmless.
> transaction id consumption is ~ 350000 per day (extrapolated from 16
> hours).
> No, the Server has been up for about 2 month (regular reboot due to
> kernel and postgresql upgrade to 8.1.8), was running before for 7
> month flawless, and before that i migrated from 8.0 to 8.1.4 with a
> complete dump/restore).
And when was the message logged?
--
Alvaro Herrera http://www.advogato.org/person/alvherre
"Saca el libro que tu religión considere como el indicado para encontrar la
oración que traiga paz a tu alma. Luego rebootea el computador
y ve si funciona" (Carlos Duclós)