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.

http://www.postgresql.org/docs/9.3/static/datatype-datetime.html#DATATYPE-TI...

-Will

On Tue, Jun 17, 2014 at 4:29 PM, Neil.Burdett@csiro.au wrote:

Hi 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?)

Thanks Neil

---

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: http://lists.bx.psu.edu/

To search Galaxy mailing lists use the unified search at: http://galaxyproject.org/search/mailinglists/

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: 1) /etc/timezone 2) run psql and execute 'show timezone;' If those values look reasonable, then I'm out of suggestions.

-Will

On Tue, Jun 17, 2014 at 8:12 PM, Neil.Burdett@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 zone # abbreviations. Currently, there are # 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 it.

Neil

*From:* Will Holtz [wholtz@lygos.com] *Sent:* Wednesday, June 18, 2014 10:25 AM *To:* Burdett, Neil (CCI, Herston - RBWH) *Cc:* galaxy-dev@lists.bx.psu.edu *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.

http://www.postgresql.org/docs/9.3/static/datatype-datetime.html#DATATYPE-TI...

-Will

On Tue, Jun 17, 2014 at 4:29 PM, Neil.Burdett@csiro.au wrote:

...

Hi 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?)

Thanks Neil

---

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: http://lists.bx.psu.edu/

To search Galaxy mailing lists use the unified search at: http://galaxyproject.org/search/mailinglists/