PostgreSQL Installation/Configuration

From Rhomicom Wiki
Revision as of 14:38, 10 March 2021 by Admin (talk | contribs) (→‎CentOS 8)
Jump to navigation Jump to search


Other Tips

 su postgres
 psql
 SHOW TIMEZONE;
 SELECT * FROM pg_timezone_names;
 SET TIMEZONE='Asia/Manila';
 sudo systemctl restart postgresql.service

CentOS 8

 date
 timedatectl 
 timedatectl list-timezones
 sudo timedatectl set-timezone Africa/Accra