On 21/03/11 11:00 AM, Tom Lane wrote: > "Etienne Robillard" <e...@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 >
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: e...@gthcfoundation.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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
