Access postgresql on host from your container

Make sure that you can access your postgresql using: 

psql -U postgres -h localhost -W 

Docker

Install Docker (skip if you have installed docker before)

- sudo apt update

- sudo apt install apt-transport-https ca-certificates curl software-properties-common

- curl -fsSL https://download.docker.com/linux/ubuntu/gpg | sudo apt-key add -

- sudo add-apt-repository "deb [arch=arm64] https://download.docker.com/linux/ubuntu $(lsb_release -cs) stable" (I'm using arm processor)

- sudo apt update

- sudo apt install docker-ce

- sudo systemctl status docker (make sure status is active)

- sudo usermod -aG docker ${USER}

- su - ${USER}

- id -nG

o ifconfig docker0 check your host ip on docker

example:

ifconfig docker0 docker0: flags=4099<UP,BROADCAST,MULTICAST> mtu 1500 inet 172.17.0.1 netmask 255.255.0.0 broadcast 172.17.255.255 ether 02:42:54:c5:b2:d1 txqueuelen 0 (Ethernet) RX packets 0 bytes 0 (0.0 B) RX errors 0 dropped 0 overruns 0 frame 0 TX packets 0 bytes 0 (0.0 B) TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0

o Running PostgreSQL in Docker

docker run --name my-postgres -e POSTGRES_PASSWORD=mysecretpassword -d -p 5432:5432 postgres

o on your container do some migration (if you are using laravel)

docker exec -it <your-laravel-container> bash

php artisan migrate