Hi,
I am experiencing the following anomaly while using postgres database:
Time is being interpreted incorrectly when I set time zone to UTC -6
(Central America).
Time shown when I query "SELECT NOW()" is 1 hour ahead of system time.
PS: Central america does not have daylight saving. That might no
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-SERV
Hi, thanks for the responses. Here are updates from my end:
1. I am in Costa Rica, using Windows Server 2008 R2/Windows 2003 with
PostgreSQL 8.3/9.0
2. System Date/Time Settings shows "CST/Central America" with UTC-6 as extra
display
system timezone: (using command: systeminfo)
Time Zone:
Hi,
Thanks for the replies and confirmation.
Can you provide me with any defect number or some equivalent for tracking
purpose?
Regards, Pratik
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Timezone-issues-with-Postgres-tp4809498p4844991.html
Sent from the PostgreSQL
We have a similar issue with postgres 9.0.1
Any ideas?
I dint see any updates in the 9.1 release notes.. Has this issue been
addressed?
Regards,
Pratik Chirania
Hewlett-Packard
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/BUG-5578-postrgesql-database-crash-tp2259469p
We have a similar issue with postgres 9.0.1
Any ideas?
I dint see any updates in the 9.1 release notes.. Has this issue been
addressed?
Regards,
Pratik Chirania
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/BUG-5578-postrgesql-database-crash-tp2259469p5077868.html
