8.2.3 initdb fails - invalid value for parameter "timezone_abbreviations": "Default"

From: "Markus Wollny" <Markus(dot)Wollny(at)computec(dot)de>
To: <pgsql-general(at)postgresql(dot)org>
Subject: 8.2.3 initdb fails - invalid value for parameter "timezone_abbreviations": "Default"
Date: 2007-02-12 11:19:18
Message-ID: 28011CD60FB1724DBA4442E38277F626047B4F53@hermes.computec.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello!

I've just tried to initdb a fresh install of PostgreSQL 8.3.2 on Debian
Etch (testing). My configure settings were
./configure --prefix=/opt/pgsql --datadir=/var/lib/pgsql/data/base
--enable-locale --with-perl --enable-odbc --with-java

This is what happens:

postgres(at)etchvm:~$ /opt/pgsql/bin/initdb -D -locale=de_DE.UTF-8
/var/lib/pgsql/data/
initdb: file "/var/lib/pgsql/data/base/postgres.bki" does not exist
This means you have a corrupted installation or identified
the wrong directory with the invocation option -L.

So I use the -L switch and try again:

postgres(at)etchvm:~$ /opt/pgsql/bin/initdb -D -locale=de_DE.UTF-8
/var/lib/pgsql/data/base -L /var/lib/pgsql/data/input/
The files belonging to this database system will be owned by user
"postgres".
This user must also own the server process.

The database cluster will be initialized with locale de_DE.UTF-8.
The default database encoding has accordingly been set to UTF8.

fixing permissions on existing directory /var/lib/pgsql/data/base ... ok
creating subdirectories ... ok
selecting default max_connections ... 10
selecting default shared_buffers/max_fsm_pages ... 400kB/20000
creating configuration files ... ok
creating template1 database in /var/lib/pgsql/data/base/base/1 ...
FATAL: invalid value for parameter "timezone_abbreviations": "Default"
child process exited with exit code 1
initdb: removing contents of data directory "/var/lib/pgsql/data/base"

postgres(at)etchvm:~$ ls -l /var/lib/pgsql/data/input/
insgesamt 624
drwxr-xr-x 2 postgres daemon 4096 2007-02-11 03:22 contrib
-rw-r--r-- 1 postgres daemon 41682 2007-02-11 03:19
conversion_create.sql
-rw-r--r-- 1 postgres daemon 82686 2007-02-11 03:19
information_schema.sql
-rw-r--r-- 1 postgres daemon 3257 2007-02-11 03:19 pg_hba.conf.sample
-rw-r--r-- 1 postgres daemon 1460 2007-02-11 03:19
pg_ident.conf.sample
-rw-r--r-- 1 postgres daemon 542 2007-02-11 03:19
pg_service.conf.sample
-rw-r--r-- 1 postgres daemon 335770 2007-02-11 03:19 postgres.bki
-rw-r--r-- 1 postgres daemon 61773 2007-02-11 03:19
postgres.description
-rw-r--r-- 1 postgres daemon 15322 2007-02-11 03:19
postgresql.conf.sample
-rw-r--r-- 1 postgres daemon 40 2007-02-11 03:19
postgres.shdescription
-rw-r--r-- 1 postgres daemon 211 2007-02-11 03:19 psqlrc.sample
-rw-r--r-- 1 postgres daemon 2689 2007-02-11 03:19
recovery.conf.sample
-rw-r--r-- 1 postgres daemon 22311 2007-02-11 03:19 sql_features.txt
-rw-r--r-- 1 postgres daemon 13385 2007-02-11 03:19 system_views.sql
drwxr-xr-x 19 postgres daemon 4096 2007-02-11 03:19 timezone
drwxr-xr-x 2 postgres daemon 4096 2007-02-11 03:19 timezonesets

postgres(at)etchvm:~$ ls -l /var/lib/pgsql/data/input/timezonesets/Default
-rw-r--r-- 1 postgres daemon 28709 2007-02-11 03:19
/var/lib/pgsql/data/input/timezonesets/Default

LC_time is set to de_DE, LC_ALL is set to de_DE.UTF-8.

Does anybody have an idea what's going wrong here?

Kind regards

Markus

Computec Media AG
Sitz der Gesellschaft und Registergericht: Furth (HRB 8818)
Vorstandsmitglieder: Johannes S. Gozalan (Vorsitzender) und Niels Herrmann
Vorsitzender des Aufsichtsrates: Jurg Marquard
Umsatzsteuer-Identifikationsnummer: DE 812 575 276

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Victor Adolfsson 2007-02-12 12:26:12 How to avoid using sequential scan
Previous Message Edwin Eyan Moragas 2007-02-12 09:42:25 Re: Priorities for users or queries?