Difference between revisions of "PostgreSQL Installation/Configuration"

From Rhomicom Wiki
Jump to navigation Jump to search
Line 9: Line 9:
 
   sudo systemctl restart postgresql.service
 
   sudo systemctl restart postgresql.service
  
==CentOS 8==
+
== CentOS 8 ==
date
+
  date
timedatectl  
+
  timedatectl  
timedatectl list-timezones
+
  timedatectl list-timezones
sudo timedatectl set-timezone Africa/Accra
+
  sudo timedatectl set-timezone Africa/Accra

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