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'