"Etienne Robillard" <erob@gthcfoundation.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