8.2.3 initdb fails - invalid value for parameter "timezone_abbreviations": "Default"
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@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@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@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@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
"Markus Wollny" <Markus.Wollny@computec.de> writes:
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
I don't think --datadir means what you think (hint: its normal value for
that --prefix would be /opt/pgsql/share). Leave that switch out.
regards, tom lane