Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to set timezone for Postgres 9.4 permanently

Tags:

postgresql

I'm running Postgres 9.4. Every time I change it it's returning to default GMT after I reboot,

> $ psql -c 'show timezone'   

TimeZone

>  US/Central

Is there a parameter option to be added in postgres.conf?

like image 906
Jecki Avatar asked Sep 06 '15 11:09

Jecki


1 Answers

You can set timezone param into pgsql/data/postgresql.conf file:

timezone = 'US/Central'

and then restart postgresql sever.

like image 77
Valery Viktorovsky Avatar answered Oct 22 '22 18:10

Valery Viktorovsky