Re: BUG #5937: initdb: FATAL error: could not open relation with OID 2608

On 22/03/11 10:51 AM, Alvaro Herrera wrote:
> Excerpts from Etienne Robillard's message of lun mar 21 12:29:01 -0300 2011:
>
>
>> $ md5sum postgresql-8.4.7.tar.gz
>> 4771d4ae4fd9e7e9b92c22253517508d postgresql-8.4.7.tar.gz
>>
>> The detached MD5 signature matches the tarball I used for compiling
>> postgresql server so I don't think
>> its necessary to try downloading another. Maybe this is strictly a 8.4.x
>> issue but will need to verify
>> by downgrading to 8.3.x...
>>
> 8.4.x has been tested by hundreds of machines. I build it here on a
> Debian machine at least once a week and I have never seen this problem.
> I don't think it's a generic PG problem; maybe there's something wrong
> with your machine or setup. Have you tested the hardware? Is the
> error reproducible exactly in the same way every time? (if not, it might
> suggest a hardware problem -- did you try memtest86?). If it's not a
> hardware problem, how did you compile it?
>
>

yes the error is reproduced in both 8.4.7 and 8.4.6...

erob(at)localhost:~/work/postgresql-8.4.7$ head config.log

This file contains any messages produced by compilers while
running configure, to aid debugging if configure makes a mistake.

It was created by PostgreSQL configure 8.4.7, which was
generated by GNU Autoconf 2.61. Invocation command line was

$ ./configure --prefix=/usr/local/pgsql --with-libxml --disable-debug
--enable-thread-safety --with-CC=llvm-gcc --with-openssl
--with-libs=/usr/lib --with-includes=/usr/include

I also just noticed the compiler was set to llvm-gcc and not gcc4. I
will try again
with gcc 4.4.5.

Regards,

--
Etienne Robillard

Company: Green Tea Hackers Club
Occupation: Software Developer (and CEO)
E-mail: erob(at)gthcfoundation(dot)org
Work phone: 450-936-2123
Website (Company): https://gthc.org/
Website (Blog): https://gthc.org/blog/
PGP public key fingerprint: F2A9 32EA 8E7C 460F 1728 A1A7 649C 7F17 A086 DDEC

During times of universal deceit, telling the truth becomes a revolutionary act. -- George Orwell

If a free society cannot help the many who are poor, it cannot save the few who are rich. -- John F. Kennedy