Getting start

Applications

• sudo apt update
• sudo apt upgrade
• sudo apt install -y vim snap build-essential
• Install VSCode sudo snap install code --classic
• Install Postman sudo snap install postman

PostgreSQL

• Add apt repository

sudo vim /etc/apt/sources.list.d/pgdg.list

• Paste

deb http://apt.postgresql.org/pub/repos/apt/ bionic-pgdg main

• Then run

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

• Trust connections to avoid password asking

sudo vim /etc/postgresql/12/main/pg_hba.conf

• Change all the methods to trust

# Database administrative login by Unix domain socket
local   all             postgres                                trust

# TYPE  DATABASE        USER            ADDRESS                 METHOD

# "local" is for Unix domain socket connections only
local   all             all                                     trust
# IPv4 local connections:
host    all             all             127.0.0.1/32            trust
# IPv6 local connections:
host    all             all             ::1/128                 trust

Essential packages

sudo apt install libssl-dev zlib1g-dev automake autoconf libncurses5-dev curl