PostgreSQL installation on linuxmint

See also

• https://r00t4bl3.com/post/how-to-install-postgresql-12-on-linux-mint-19-tara-19-1-tessa-19-2-tina-19-3-tricia

• https://wiki.postgresql.org/wiki/Apt

• 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
    • The postgres user
    • The postgres database
    • The psql Command Line Utility
  • Login and Connect as Default User
  • Changing the Password