Skip site navigation (1) Skip section navigation (2)

Re: Timezone issues with Postrres

From: pratikchirania <pratik(dot)chirania(at)hp(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Timezone issues with Postrres
Date: 2011-09-21 07:16:58
Message-ID: 1316589418035-4825401.post@n5.nabble.com (view raw or flat)
Thread:
Lists: pgsql-bugs
Hi,

Thanks for your response.
I tried your suggestion and got the following outputs:

C:\PostgreSQL\9.0\bin>pg_config
BINDIR = C:/POSTGR~1/9.0/bin
DOCDIR = C:/POSTGR~1/9.0/doc
HTMLDIR = C:/POSTGR~1/9.0/doc
INCLUDEDIR = C:/POSTGR~1/9.0/include
PKGINCLUDEDIR = C:/POSTGR~1/9.0/include
INCLUDEDIR-SERVER = C:/POSTGR~1/9.0/include/server
LIBDIR = C:/POSTGR~1/9.0/lib
PKGLIBDIR = C:/POSTGR~1/9.0/lib
LOCALEDIR = C:/POSTGR~1/9.0/share/locale
MANDIR = C:/PostgreSQL/9.0/man
SHAREDIR = C:/POSTGR~1/9.0/share
SYSCONFDIR = C:/PostgreSQL/9.0/etc
PGXS = C:/PostgreSQL/9.0/lib/pgxs/src/makefiles/pgxs.mk
CONFIGURE = --enable-thread-safety --enable-integer-datetimes --enable-nls
--wit
h-ldap --with-ossp-uuid --with-libxml --with-libxslt --with-tcl --with-perl
--wi
th-python
VERSION = PostgreSQL 9.0.1

C:\PostgreSQL\9.0\bin>pg_config --prefix
pg_config: invalid argument: --prefix
Try "pg_config --help" for more information.



I have postgres version 9.0.1:
C:\PostgreSQL\9.0\bin>pg_config --version
PostgreSQL 9.0.1

The command clearly does not return '--with-system-tzdata'. I am using
Windows server 2008 R2. The TZ data must be working fine as other
applications on the OS are working fine. The issue is also reproducible on
Postgre version 8.3.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Timezone-issues-with-Postgres-tp4809498p4825401.html
Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.

In response to

Responses

pgsql-bugs by date

Next:From: Lionel Elie MamaneDate: 2011-09-21 08:25:17
Subject: Re: BUG #6216: Calling PQconnectdbParams from C++ with a char**
Previous:From: Tom LaneDate: 2011-09-20 23:43:25
Subject: Re: BUG #6216: Calling PQconnectdbParams from C++ with a char**

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group