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
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! Mail Mobile
Take Yahoo! Mail with you! Check email on your mobile phone.
Locked
