PostgreSQL Installation/Configuration

Other Tips

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

CentOS 8 TIMEZONE

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