Hmm. You are probably very similar to my setup (ubuntu 12.04, Postgres
9.1), and my Postgres install did manage to use the system timezone. I
would check two things:
2) run psql and execute 'show timezone;'
If those values look reasonable, then I'm out of suggestions.
On Tue, Jun 17, 2014 at 8:12 PM, <neil.burd...@csiro.au> wrote:
> Thanks, but looking at /etc/postgresql/9.1/main/postgresql.conf i have
> the following:
> #timezone = '(defaults to server environment setting)'
> #timezone_abbreviations = 'Default' # Select the set of available time
> # abbreviations. Currently, there
> # Default
> # Australia
> # India
> # You can create your own file in
> # share/timezonesets/.
> So i assume it should get the time from the ubuntu machine it runs on. I
> have not done any configuration to the postgresql database. Only installing
> *From:* Will Holtz [who...@lygos.com]
> *Sent:* Wednesday, June 18, 2014 10:25 AM
> *To:* Burdett, Neil (CCI, Herston - RBWH)
> *Cc:* email@example.com
> *Subject:* Re: [galaxy-dev] Postgresql database time wrong...
> Postgres generally stores datatime fields in GMT, and then translates
> them to the local time zone when generating a query. Check the TimeZone
> variable in your postgres.conf.
> On Tue, Jun 17, 2014 at 4:29 PM, <neil.burd...@csiro.au> wrote:
>> I have quite a strange issue. I have a local install of Galaxy setup.
>> When I type 'date' on my Ubuntu machine I get something like:
>> Wed Jun 18 09:25:22 EST 2014
>> When i then execute a job and look in the database at the create_time i.e.
>> # select create_time from job order by create_time;
>> I get
>> 2014-06-17 23:20:00.133828
>> So about 10 hours different. Is there some configuration I need to set as
>> Brisbane is 10hrs ahead of GMT (coincidence?)
>> Please keep all replies on the list by using "reply all"
>> in your mail client. To manage your subscriptions to this
>> and other Galaxy lists, please use the interface at:
>> To search Galaxy mailing lists use the unified search at:
Please keep all replies on the list by using "reply all"
in your mail client. To manage your subscriptions to this
and other Galaxy lists, please use the interface at:
To search Galaxy mailing lists use the unified search at: