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
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? |