PostgreSQL e TimeZone: differenze tra le pagine

Da GazziNet.
(Differenze fra le pagine)
Vai alla navigazione Vai alla ricerca
Nessun oggetto della modifica
 
(Creata pagina con "Setting TimeZone: timedatectl set-timezone Europe/Rome Test: date timedatectl Local time: lun 2023-06-12 10:24:49 CEST Universal time: lun 2023-06-12 08:24:49 UTC RTC time: lun 2023-06-12 08:24:49 Time zone: Europe/Rome (CEST, +0200) System clock synchronized: yes NTP service: active RTC in local TZ: no")
 
Riga 1: Riga 1:
Client Consigliato: DBeaver
Setting TimeZone:
timedatectl set-timezone Europe/Rome


https://blog.mclaughlinsoftware.com/2022/11/24/almalinuxpostgresql/


 
Test:  
Sistema di installazione suggerito: https://www.postgresql.org/download/
date
 
  timedatectl
  # Install the repository RPM:
              Local time: lun 2023-06-12 10:24:49 CEST
sudo dnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-9-x86_64/pgdg-redhat-repo-latest.noarch.rpm
              Universal time: lun 2023-06-12 08:24:49 UTC
 
              RTC time: lun 2023-06-12 08:24:49
# Disable the built-in PostgreSQL module:
              Time zone: Europe/Rome (CEST, +0200)
sudo dnf -qy module disable postgresql <-- Importante!!
              System clock synchronized: yes
 
              NTP service: active
# Install PostgreSQL:
              RTC in local TZ: no
sudo dnf install -y postgresql15-server
 
# Optionally initialize the database and enable automatic start:
sudo /usr/pgsql-15/bin/postgresql-15-setup initdb
sudo systemctl enable postgresql-15
sudo systemctl start postgresql-15
 
Database folder: /var/lib/pgsql/15/data/
 
su - postgres
createuser -s admin
Richiamare: psql
ALTER USER admin WITH PASSWORD '****';
 
Nel file pg_hba modificare es.:  
 
host    all            admin          172.16.0.0/24            password (Utente admin abilitato ad accedere da tutti gli ip della rete 172.16.0.x via TCP/IP in tutti i DB)

Versione delle 08:26, 12 giu 2023

Setting TimeZone: 

timedatectl set-timezone Europe/Rome


Test: 

date
timedatectl
              Local time: lun 2023-06-12 10:24:49 CEST
              Universal time: lun 2023-06-12 08:24:49 UTC
              RTC time: lun 2023-06-12 08:24:49
              Time zone: Europe/Rome (CEST, +0200)
              System clock synchronized: yes
              NTP service: active
              RTC in local TZ: no
Estratto da "http://wiki.gazzi.net/index.php?title=PostgreSQL&oldid=106"