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

Поиск
Список
Период
Сортировка
От Markus Wollny
Тема 8.2.3 initdb fails - invalid value for parameter "timezone_abbreviations": "Default"
Дата
Msg-id 28011CD60FB1724DBA4442E38277F626047B4F53@hermes.computec.de
обсуждение исходный текст
Ответы Re: 8.2.3 initdb fails - invalid value for parameter "timezone_abbreviations": "Default"  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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@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



В списке pgsql-general по дате отправления:

Предыдущее
От: "Edwin Eyan Moragas"
Дата:
Сообщение: Re: [ADMIN] Priorities for users or queries?
Следующее
От: "Victor Adolfsson"
Дата:
Сообщение: How to avoid using sequential scan