Preparing your local Postges DB. Resolving timezone headache for developers.
Preparing your local Postges DB Resolving timezone headache for developers. To set your PostgreSQL server time to UTC, you can change the setting globally, per database, per user, or for a single session. Permanent Global Change Modify the main configuration file to set the default for the entire server. Locate the file : Find your postgresql.conf file by running this SQL command in your database: SHOW config_file; Edit the file : Open postgresql.conf and find the timezone parameter. Change it to: text timezone = 'UTC' Use code with caution. Apply changes : Reload the configuration without restarting the server by running: SELECT pg_reload_conf(); (Alternatively, use pg_ctl reload from your terminal) . Permanent Database or User Change If you only want specific databases or users to use UTC, use these SQL commands: Per Database: ALTERDATABASE your_database_name SET timezone TO'UTC'; Per User : ALTER USER your...
