could not select a suitable default timezone on Initdb, 8.3.3, Windows 2008 x64

From: "JEAN-PIERRE PELLETIER" <pelletier_32(at)sympatico(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: could not select a suitable default timezone on Initdb, 8.3.3, Windows 2008 x64
Date: 2008-06-24 15:17:42
Message-ID: BAY133-F407B4EC1415CE30F58BC2295A10@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Browse pgsql-general by date

  From Date Subject
Next Message Michael Shulman 2008-06-24 15:28:00 Re: what are rules for?
Previous Message Tom Lane 2008-06-24 15:04:25 Re: backslashes in 8.3.3