Re: [BUGS] BUG #5578: postrgesql database crash

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

Re: [BUGS] BUG #5578: postrgesql database crash

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

Re: [BUGS] Timezone issues with Postrres

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

Re: [BUGS] Timezone issues with Postrres

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:

Re: [BUGS] Timezone issues with Postrres

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

[BUGS] Timezone issues with Postrres

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