PostgreSQL installation ¶ PostgreSQL 15 installation PostgreSQL installation on Debian 12 bookworm sudo apt install postgresql-15 tree /etc/postgresql Le nouvel utilisateur ‘postgres’ (PostgreSQL administrator) sous GNU/Linux Changer le mot de passe par défaut de postgres Changer le mode d’accès dans le fichier /etc/postgresql/15/main/pg_hba.conf Annexes PostgreSQL 12 installation PostgreSQL installation on Debian PostgreSQL installation on Debian 10 buster PostgreSQL installation on linuxmint PostgreSQL installation on linuxmint tara 19 PostgreSQL timezones Description Dont do this Don’t use CURRENT_TIME Be Aware of Timezones by Haki Benita Avoid Transformations on Indexed Fields by Haki Benita Use BETWEEN Only For Inclusive Ranges PostgreSQL Data Types: Date, Timestamp, and Time Zones by Tapoueh tz.sql Table pg_timezone_names Setting the timezone parameter (please use UTC timezone) show timezone; select clock_timestamp(); SELECT now() SELECT now() AT TIME ZONE current_setting(‘TimeZone’); SELECT now() AT TIME ZONE ‘Europe/Paris’; SELECT now() AT TIME ZONE ‘UTC’; PostgreSQL docker PostgreSQL docker examples PostgreSQL docker example 1