On Tue, May 18, 2010 at 8:15 PM, Brad Ediger <brad@xxxxxxxxxxxxxx> wrote: > I am experiencing this error trying to set the connection time zone to > UTC on PostgreSQL 8.4.4: > > postgres=# set time zone 'UTC'; > ERROR: unrecognized time zone name: "UTC" Answered my own question -- it was my Prefix Portage install missing the zoneinfo database ($EPREFIX/usr/share/zoneinfo/UTC). Working great now. -be -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general