Difference between revisions of "PostgreSQL Installation/Configuration"
Jump to navigation
Jump to search
(Created page with " ==Other Tips== su postgres psql SHOW TIMEZONE; SELECT * FROM pg_timezone_names; SET TIMEZONE='Asia/Manila'; sudo systemctl restart postgresql.service ==CentOS 8== date time...") |
|||
| Line 1: | Line 1: | ||
| − | ==Other Tips== | + | == Other Tips == |
| − | su postgres | + | su postgres |
| − | psql | + | psql |
| − | SHOW TIMEZONE; | + | SHOW TIMEZONE; |
| − | SELECT * FROM pg_timezone_names; | + | SELECT * FROM pg_timezone_names; |
| − | SET TIMEZONE='Asia/Manila'; | + | SET TIMEZONE='Asia/Manila'; |
| − | sudo systemctl restart postgresql.service | + | sudo systemctl restart postgresql.service |
==CentOS 8== | ==CentOS 8== | ||
Revision as of 14:38, 10 March 2021
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