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

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