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.
-Will