Tom Lane wrote:
Joseph S <[EMAIL PROTECTED]> writes:
On one of my servers postgres thinks that we're back on standard time
already:
What's its TimeZone setting?
On the server that is working:
=> show TimeZone;
TimeZone
US/Eastern
(1 row)
On the one that is broken:
show Tim
Joseph S <[EMAIL PROTECTED]> writes:
> On one of my servers postgres thinks that we're back on standard time
> already:
What's its TimeZone setting? What is the mod date of the corresponding
file in the $SHAREDIR/timezone/ directory (where $SHAREDIR means
whatever pg_config --sharedir says)?
It
On one of my servers postgres thinks that we're back on standard time
already:
[local]:db=# select current_timestamp;
now
---
2007-10-29 15:06:10.049795-05
(1 row)
Time: 0.807 ms
[local]:db=# select version();
