I did the install despite the errors. After the install, I ran initdb
and it failed the first time with:
creating configuration files ... ok
creating template1 database in /usr/local/pgsql/data/base/1 ... ok
initializing pg_authid ... FATAL: function flatfile_update_trigger()
does not exist
STATEMENT: CREATE TRIGGER pg_sync_pg_database AFTER INSERT OR
UPDATE OR DELETE ON pg_database FOR EACH STATEMENT EXECUTE
PROCEDURE flatfile_update_trigger();
I ran it a second time and it went through without errors. To tempt
fate, I removed the data directory and tried it a third time. Then it
hung on "creating system views ..."
A backtrace of all stack frames of initdb at the time showed:
(gdb) bt
#0 0x00002b3442a11836 in _IO_proc_close@@GLIBC_2.2.5 () from /lib64/
libc.so.6
#1 0x00002b3442a1b672 in _IO_new_file_close_it () from /lib64/libc.so.6
#2 0x00002b3442a0f9d8 in fclose@@GLIBC_2.2.5 () from /lib64/libc.so.6
#3 0x0000000000405b66 in pclose_check ()
#4 0x000000000040313a in setup_sysviews ()
#5 0x0000000000404f9a in main ()
Any ideas what might be wrong? Hardware? OS? Maybe I should try
something other than SUSE 10.1?
Brian Wipf
<brian@clickspace.com>