PostgreSQL installation on Debian

• https://www.postgresql.org/download/linux/debian/

• PostgreSQL installation on Debian 10 buster
  • Caractéristiques de la machine GNU/Linux
  • Create the etc/apt/sources.list.d/pgdg.list file
  • tree /etc/postgresql
    • main/postgresql.conf
    • Setting the UTC timezone parameter in main/postgresql.conf
    • main/pg_hba.conf
  • dpkg -l | grep postgres
  • netstat -nl | grep postgres
  • service postgresql status
  • nxi -Fxxz
  • Configuring Postgres for Use
    • The postgres user
    • The postgres database
    • The psql Command Line Utility
  • Login and Connect as Default User
  • Changing the Password