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
> 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
$ md5sum 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...
Company: Green Tea Hackers Club
Occupation: Software Developer (and CEO)
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
pgsql-bugs by date
|Next:||From: Robert Haas||Date: 2011-03-21 15:49:42|
|Subject: Re: TO_CHAR(timestamptz,datetimeformat) wrong after DST change|
|Previous:||From: Tom Lane||Date: 2011-03-21 15:00:39|
|Subject: Re: BUG #5937: initdb: FATAL error: could not open relation with OID 2608 |