Skip site navigation (1) Skip section navigation (2)

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

From: Etienne Robillard <erob(at)gthcfoundation(dot)org>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5937: initdb: FATAL error: could not open relation with OID 2608
Date: 2011-03-22 22:23:04
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
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.


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):
Website (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

In response to


pgsql-bugs by date

Next:From: Tom LaneDate: 2011-03-22 22:26:37
Subject: Re: BUG #5937: initdb: FATAL error: could not open relation with OID 2608
Previous:From: John R PierceDate: 2011-03-22 20:56:48
Subject: Re: psql crashes with bad history file in 9.0.3

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group