Re: [BUGS] BUG #3362: xlog corruption just after initdb on irix

Le 06/06/2007 18:04, Tom Lane a écrit:

Hi,

> Herve Boulouis <amon@sockar.homeip.net> writes:
> > The mipspro compiler is a proprietary product and I cannot get the
> > necessary updates so for now I am unable to verify this theory. Anyway,
> > maybe you should a add a note in the pg irix faq to use the 7.4.4m version
> > of mipspro when building the sources ?
>
> Maybe, but I'd like confirmation of the theory first. Please let me
> know how it goes when you get hold of 7.4.4m ...

I finally got the 7.4.4m update and repeated the entire test (compile, install, initdb, start/stop multiple times) and the problem has gone away.

My test server hasn't changed since I reported the bug, so I think you can add a note in the pg documentation regarding the MIPSPro version to use. (7.4.4m ok, 7.4.1m broken, dunno about the intermediate versions)

-- 
Herve Boulouis

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match