Hopefully this is a quick one to answer, but it's got me tearing my
hair out.
Custom built postgresql 8.3.5 using the pkgsrc build system on OS X
Leopard; when running: /usr/pkg/bin/initdb -D /usr/pkg/pgsql/data
(I also tried adding the -d flag but no other useful information was
shown)
as the pgsql user, it seems to be dying with a dictionary problem as
follows:
sh-3.2$ /usr/pkg/bin/initdb -D /usr/pkg/pgsql/data
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 en_US.UTF-8.
The default database encoding has accordingly been set to UTF8.
The default text search configuration will be set to "english".
fixing permissions on existing directory /usr/pkg/pgsql/data ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers/max_fsm_pages ... 12MB/76800
creating configuration files ... ok
creating template1 database in /usr/pkg/pgsql/data/base/1 ... ok
initializing pg_authid ... ok
initializing dependencies ... ok
creating system views ... ok
loading system objects' descriptions ... ok
creating conversions ... ok
creating dictionaries ... FATAL: could not access file
"$libdir/libdict_snowball": No such file or directory
STATEMENT: -- Language-specific snowball dictionaries
-- $PostgreSQL:
pgsql/src/backend/snowball/snowball_func.sql.in,v 1.2
2007/09/03 02:30:43 tgl Exp $$
SET search_path = pg_catalog;
CREATE FUNCTION dsnowball_init(INTERNAL)
RETURNS INTERNAL AS '$libdir/libdict_snowball',
'dsnowball_init'
LANGUAGE C STRICT;
....(snip)
......many many lines of snowball specific SQL and then finally....
ALTER TEXT SEARCH CONFIGURATION turkish ADD MAPPING
FOR asciiword, hword_asciipart, asciihword
WITH turkish_stem;
ALTER TEXT SEARCH CONFIGURATION turkish ADD MAPPING
FOR word, hword_part, hword
WITH turkish_stem;
child process exited with exit code 1
initdb: removing contents of data directory "/usr/pkg/pgsql/data"
===============
So, presumably the fatal error which resulted in exit code 1 was:
FATAL: could not access file "$libdir/libdict_snowball": No such file
If so, how to fix so that initdb can complete?
Further details:
pg_config --libdir
/Volumes/pkgsrc/pkg/lib
pg_config --pkglibdir
/Volumes/pkgsrc/pkg/lib/postgresql
sh-3.2$ ls -l /Volumes/pkgsrc/pkg/lib/postgresql | grep snowball
-rwxr-xr-x 1 root wheel 341480 Feb 27 17:06
libdict_snowball.0.0.0.dylib
lrwxr-xr-x 1 root wheel 28 Feb 27 17:06
libdict_snowball.0.dylib -> libdict_snowball.0.0.0.dylib
lrwxr-xr-x 1 root wheel 28 Feb 27 17:06 libdict_snowball.dylib
-> libdict_snowball.0.0.0.dylib
-rwxr-xr-x 1 root wheel 893 Feb 27 17:06 libdict_snowball.la
And I've symlinked these all from /Volumes/pkgsrc/pkg/lib as well, but
initdb still fails to complete.
Any help will be gratefully apreciated.
Regards,
Jonathan.
