Installing Environment

<pre class="wp-block-code">```
sudo apt update
sudo apt install snapd

sudo apt install -y default-jdk
sudo snap install node --classic
sudo npm install -g @angular/cli --unsafe-perm=true --allow-root

sudo snap install intellij-idea-ultimate --classic --edge
sudo snap install --classic code 
sudo snap install postman

sudo snap install http

<figure class="wp-block-embed"><div class="wp-block-embed__wrapper">https://www.digitalocean.com/community/tutorials/how-to-install-postgresql-on-ubuntu-20-04-quickstart </div></figure>## Setup PostgreSQL Database Server

We are going to show how to install PostgreSQL database on a Debian Linux system.

$ sudo apt-get install postgresql  
```

Check status

```
$ /etc/init.d/postgresql status
```

Add password for the postgress account

```
$ sudo -u postgres psql postgres
psql (9.5.10)
Type "help" for help.

postgres=# \password postgres
Enter new password: 
Enter it again: 
```

Create a new user with a password

```
$ sudo -u postgres createuser --interactive --password usertest
Shall the new role be a superuser? (y/n) n
Shall the new role be allowed to create databases? (y/n) y
Shall the new role be allowed to create more new roles? (y/n) n
Password: 
```

Create a new database test\_db with the new role as the owner

```
$ sudo -u postgres createdb test_db -O usertest
```

Now edit the `pg_hba.conf` file to enable connection

```
$ sudo vi /etc/postgresql/12/main/pg_hba.conf
```

By changing the lines below with **trust**

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

Restart the server

```
$ sudo service postgresql restart
```

Check if the new role can access the new database

```
$ psql -U user_test -d test_db -W 
```