it also looks like the view pg_timezone_names is empty in the problem
installation. What loads this view?
psql (8.4.5)
Type "help" for help.
postgres=# select * from pg_timezone_names;
name | abbrev | utc_offset | is_dst
------+--------+------------+--------
(0 rows)
postgres=#
On 3/15/11 2:18 PM, Scott Marlowe wrote:
On Tue, Mar 15, 2011 at 12:17 PM, Scott Marlowe<scott.marlowe@xxxxxxxxx> wrote:
On Tue, Mar 15, 2011 at 12:12 PM, Maria L. Wilson
<Maria.L.Wilson-1@xxxxxxxx> wrote:
when you say updating postgres - do you mean the server software? How do
you update the tz data?
Yes updating the pg software. The OS has tzdata as well, and you can
update that. But postgresql includes its own tzdata so I'm guessing
that updating pg would fix it.
I'm just a little concerned why only 2 of our machines (they are all
supposed to be the same) are having this problem.
Are they all running the same pg version?
Also are all the machines set to the same time zone?
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
