PostgreSQL 12 installation

• PostgreSQL installation on 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
    • dpkg -l | grep postgres
    • netstat -nl | grep postgres
    • service postgresql status
    • nxi -Fxxz
    • Configuring Postgres for Use
    • Login and Connect as Default User
    • Changing the Password
• PostgreSQL installation on linuxmint
  • PostgreSQL installation on linuxmint tara 19
    • Linux/mint tara
    • /etc/apt/sources.list.d/postgresql.list
    • sudo apt update
    • sudo apt upgrade
    • sudo apt install postgresql-12
    • Ajout de l’utilisateur postgres au groupe ssl-cert
    • Creating new PostgreSQL cluster 12/main
    • /usr/lib/postgresql/12/bin/initdb -D /var/lib/postgresql/12/main –auth-local peer –auth-host md5
    • pg_ctlcluster 12 main start
    • ps -ef | grep postgre
    • tree /etc/postgresql
    • dpkg -l | grep postgres
    • netstat -nl | grep postgres
    • sudo service postgresql status
    • inxi -Fxxz
    • Configuring Postgres for Use
    • Login and Connect as Default User
    • Changing the Password