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...") |
|||
| (2 intermediate revisions by the same user not shown) | |||
| 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 TIMEZONE== |
| − | date | + | date |
| − | timedatectl | + | timedatectl |
| − | timedatectl list-timezones | + | timedatectl list-timezones |
| − | sudo timedatectl set-timezone Africa/Accra | + | sudo timedatectl set-timezone Africa/Accra |
Latest revision as of 14:39, 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 TIMEZONE
date timedatectl timedatectl list-timezones sudo timedatectl set-timezone Africa/Accra