Postgres Pro
Downloads
Home   >   mailing lists

Re: Unrecognized time zone name error. - Mailing list pgsql-general

From Tom Lane
Subject Re: Unrecognized time zone name error.
Date
Msg-id 3800.1165939999@sss.pgh.pa.us
Whole thread Raw
In response to Unrecognized time zone name error.  (Brad Nicholson <bnichols@ca.afilias.info>)
Responses Re: Unrecognized time zone name error.  (Brad Nicholson <bnichols@ca.afilias.info>)
List pgsql-general
Tree view 
Brad Nicholson <bnichols@ca.afilias.info> writes:
> This seems odd.  Any idea what's going on here?

> template1=# SET TimeZone TO 'GMT';
> ERROR:  unrecognized time zone name: "GMT"

Worksforme.  Perhaps you are missing the /usr/share/pgsql/timezone/
directory (your path might vary)?

            regards, tom lane

pgsql-general by date:

Previous
From: "Greg Fairbanks"
Date:
Subject: Running initdb from another process
Next
From: Richard Huxton
Date:
Subject: Re: search_path when restoring to new db