Jorge Campins wrote:
> Dear All,
> I installed 220.127.116.11 and solved my problem. I set Windows time zone to
> "Caracas" and PostgreSQL "America/Caracas" and now they both give me the
> right time.
> WARNING: not only people in Venezuela but also people in Bolivia is
> affected by this problem. As you might recall, Windows used to have a
> single time zone for both countries, namely "Caracas/La Paz". If now you
> set Windows time zone to "La Paz", PostgreSQL 18.104.22.168 will use
> "America/Caracas" unless you specify something else in postgresql.conf.
> In this case, Windows has Bolivia's time and PostgreSQL has Venezuela's
> time. So people in Bolivia should also specify timezone in postgresql.conf.
Yeah, I've got an update that has some more timezones around here
available coming up, I think that's going to help it. But always - the
pg database of timezones is a lot more extensive than the Windows one,
so it's always a good idea to check it out.
In response to
pgsql-bugs by date
|Next:||From: Rob von Nesselrode||Date: 2008-02-11 22:22:42|
|Subject: BUG #3953: No PostGIS option in installer|
|Previous:||From: imacat||Date: 2008-02-11 18:27:21|
|Subject: Re: Vers. 8.3.0: "make check" fails dismally|