Postgresql installation

sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt/ $(lsb_release -sc)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'

wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -

sudo apt-get update

sudo apt-get install postgresql-10

stop, start, enable and check its status

sudo systemctl stop postgresql.service

sudo systemctl start postgresql.service

sudo systemctl enable postgresql.service

sudo systemctl status postgresql.service

Accessing PostgreSQL

sudo su -l postgres

Postgis installation

sudo apt install postgresql-10-postgis-scripts

Postgres conf files

psql -U postgres -c 'SHOW config_file'

cat /etc/postgresql/10/main/pg_hba.conf

Postgres port

netstat -an | grep 5432

postgresql.conf: listen_addresses = 'localhost' to listen_addresses = '*'

Postgres uninstallation

dpkg -l | grep postgres

sudo apt-get --purge remove postgresql-*

sudo apt-get --purge remove pgdg-keyring

whereis postgresql

CPU / Memory

cat /proc/cpuinfo | grep name

free -h

sudo dmidecode -t memory | more