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 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