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

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