PostgreSQL 8.0.3 : initdb fails with the time zone value WAT0 on HP-Unix platforms

From: Kathir Velu <kathir_kovai(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: PostgreSQL 8.0.3 : initdb fails with the time zone value WAT0 on HP-Unix platforms
Date: 2005-06-17 14:04:41
Message-ID: 20050617140441.77534.qmail@web53609.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello All,

PostgreSQL-8.0.3 doesnot work with time zone value WAT0 ( for West Africa Time ).
HP Unix 11.23 PA and IPF servers set the time zone value for West Africa Time as "WAT0" in it's "/etc/TIMEZONE" file.

When we try to initialize the database directories using initdb command, we get the following error,

$ initdb -D /var/opt/iexpress/postgresql
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 C.

fixing permissions on existing directory /var/opt/iexpress/postgresql... ok
creating directory /var/opt/iexpress/postgresql/base... ok
creating directory /var/opt/iexpress/postgresql/global... ok
creating directory /var/opt/iexpress/postgresql/pg_xlog... ok
creating directory /var/opt/iexpress/postgresql/pg_clog... ok
selecting default max_connections... 10
selecting default shared_buffers... 50
creating configuration files... ok
creating template1 database in /var/opt/iexpress/postgresql/base/1... FATAL: invalid value for parameter "timezone": "WAT0"

initdb: failed

When we changed the server timezone value to "WAT-01:00" in TZ environment variable
as specified in http://www.postgresql.org/docs/7.4/static/datetime-keywords.html, it worked well.

However it has to be work for time zone value "WAT0", generated by server for West Africa Time.
So possibly this could be the bug with the postgresql. Can you please provide a patch to fx this issue in PostgreSQL source ?

thanks,
Kathir.


---------------------------------
Yahoo! Sports
Rekindle the Rivalries. Sign up for Fantasy Football

Browse pgsql-general by date

  From Date Subject
Next Message Douglas McNaught 2005-06-17 14:19:51 Re: Making the DB secure
Previous Message Tom Lane 2005-06-17 13:57:33 Re: Backing up multiple databases