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: 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-21 15:29:01
Message-ID: 4D876EBD.9060502@gthcfoundation.org (view raw or flat)
Thread:
Lists: pgsql-bugs
On 21/03/11 11:00 AM, Tom Lane wrote:
> "Etienne Robillard" <erob(at)gthcfoundation(dot)org> writes:
>   
>> Could not run initdb --no-locale -D $PGDATA as pgsql 
>> user to setup the internal postgresql db:
>>     
>   
>> Script started on Mon 21 Mar 2011 07:44:29 AM EDT
>> $ /usr/local/pgsql/bin/initdb --no-locale -D $PGDATA
>> The files belonging to this database system will be owned by user "pgsql".
>> This user must also own the server process.
>>     
>   
>> The database cluster will be initialized with locale C.
>> The default database encoding has accordingly been set to SQL_ASCII.
>> The default text search configuration will be set to "english".
>>     
>   
>> fixing permissions on existing directory /var/db/pgsql/data ... ok
>> creating subdirectories ... ok
>> selecting default max_connections ... 100
>> selecting default shared_buffers ... 28MB
>> creating configuration files ... ok
>> creating template1 database in /var/db/pgsql/data/base/1 ... ok
>> initializing pg_authid ... FATAL:  could not open relation with OID 2608
>> STATEMENT:  CREATE TRIGGER pg_sync_pg_database   AFTER INSERT OR UPDATE OR
>> DELET
>>     
> That's pretty darn odd.  Is this really an unmodified copy of 8.4.7?
> What's different between your machine and all the other ones where
> initdb works just fine?
>
> 			regards, tom lane
>   

Hi,

$ 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...

kind regards,

Etienne

-- 
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


In response to

Responses

pgsql-bugs by date

Next:From: Robert HaasDate: 2011-03-21 15:49:42
Subject: Re: TO_CHAR(timestamptz,datetimeformat) wrong after DST change
Previous:From: Tom LaneDate: 2011-03-21 15:00:39
Subject: Re: BUG #5937: initdb: FATAL error: could not open relation with OID 2608

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