Initdb throws "could not select a suitable default timezone" on PostgreSQL
8.3.3
and Windows x64.
We'd like to use those settings --lc-collate=C --lc-ctype=French_Canada
pginstaller does initdb properly but not with the parameters we want.
We want upper, lower, regex, ... to process acccented characters properly
but don't care
about the collating sequence of those accented characters.
We have many indexes of varchar columns and want to avoid having both
regular indexes
and index with *_pattern_ops.
we first install PostgreSQL with pgInstaller and no initdb
we then issue:
initdb -d --pgdata="C:/Program Files (x86)/PostgreSQL/8.3/data"
--encoding=WIN1252 --lc-collate=C --lc-ctype=French_Canada --pwprompt -L
"C:/Program Files (x86)/PostgreSQL/8.3/share"
creating template1 database in C:/Program Files
(x86)/PostgreSQL/8.3/data/base/1 ...
DEBUG: TZ "US/Eastern" matches Windows timezone "Eastern Daylight Time"
LOG: could not open directory "/share/timezone": No such file or directory
LOG: could not open directory "/share/timezone": No such file or directory
FATAL: could not select a suitable default timezone
DETAIL: It appears that your GMT time zone uses leap seconds. PostgreSQL
does not support leap seconds.
DEBUG: proc_exit(1)
DEBUG: shmem_exit(1)
DEBUG: exit(1)
child process exited with exit code 1
We tried putting a copy of C:/Program Files (x86)/PostgreSQL/8.3/share in
c:/share
to get a little bit further and got this fatal error:
creating conversions ...
FATAL: could not access file "$libdir/ascii_and_mic": No such file or
directory
STATEMENT: CREATE OR REPLACE FUNCTION ascii_to_mic (INTEGER, INTEGER,
CSTRING, INTERNAL, INTEGER)
RETURNS VOID AS '$libdir/ascii_and_mic', 'ascii_to_mic' LANGUAGE C STRICT;
child process exited with exit code 1
The file ascii_and_mic.dll does exist in C:/Program Files
(x86)/PostgreSQL/8.3/lib
Thanks,
Jean-Pierre Pelletier
e-djuster
