ERROR: PrestoHttpException: Failed to start query: Time zone localtime is not supported

[akshay-hazari]

I just tried installing and setting up prestogres on ubuntu 14.04. I faced an issue in one step where it returns me the following error on this step of installation: psql -h localhost -p 9900 -U pg postgres SELECT * FROM sys.node; The above returns ERROR: PrestoHttpException: Failed to start query: Time zone localtime is not supported

[frsyuki]

Thank you for reporting. Perhaps recent Presto makes timezone validation more strict. Prestogres passes timezone session variable to Presto. I think it is now "localtime" but it needs to be a different string. Could you try following settings?:

• In postgresql.conf (located at <prestogres_data_dir>/postgres/), add timezone = 'UTC' line (or other timezone listed in http://tutorials.jenkov.com/java-date-time/java-util-timezone.html).
• Before running the SELECT query using psql command, run SET TIME ZONE TO 'UTC'