@3:00 I have had issues with mounting volumes like yours because it's not a folder-based volume and you will run into problems/loose data if you are not careful! The correct way that has worked for me everytime is; volumes: - ./data:/var/lib/postgresql/data
I have tried this but it gives permission denied error (while pointing to the directory) when my backend tries to connect with the db. I have even tried chown with 999:999 and chmod 700 but still not solved so I ended up using named volumes instead
@2:47, when setting up the data persistent capability, the host has a folder named "data". Does it mean that this "data" folder has to be created first before we run the docker-compose up command or docker desktop will create this "data" folder if one does not already exist? also @2:24, the place where the environment variables were defined, there is a hyphen "-" in front of every variables eg - POSTGRES_USER In some youtube videos, when they defined variables in the compose file, no hyphen was use. Is "-" optional?
It helped me a lot to configure the environment with Postgres without having to install on the machine, and run tests.
Thank you!
@3:00
I have had issues with mounting volumes like yours because it's not a folder-based volume and you will run into problems/loose data if you are not careful!
The correct way that has worked for me everytime is;
volumes:
- ./data:/var/lib/postgresql/data
I have tried this but it gives permission denied error (while pointing to the directory) when my backend tries to connect with the db. I have even tried chown with 999:999 and chmod 700 but still not solved so I ended up using named volumes instead
Hey, Friend!
This video helped me a lot!
Thanks!
very good video.
which vscode theme are you using?
Amaizing
@2:47, when setting up the data persistent capability, the host has a folder named "data".
Does it mean that this "data" folder has to be created first before we run the docker-compose up command or docker desktop will create this "data" folder if one does not already exist?
also
@2:24, the place where the environment variables were defined, there is a hyphen "-" in front of every variables eg - POSTGRES_USER
In some youtube videos, when they defined variables in the compose file, no hyphen was use. Is "-" optional?
Thank you dear friend! And i have a question: how i connect postgres from dbeaver ?
Thank you dear friend! only you could help me)
thanks, your save my day bro
I have tried:
as service directly
from docker images
using docker-compose
but unable to connect pgadmin to the psql server.....
Thank you for your video! Assume that I have a .tar folder on my local machine (inside Downloads), can I import that file into pgAdmin?
very helpful thanks!
Glad it helped!
Hy bro, i wanted to change my password in docker compose and i changed but it is always taking previous password, please enlighten me
It is due to the cache. After change password, you have to do >>>> docker-compose down -v
@@DailyWebCoding thank you so much brother, much appreciation 😁😁🙏
Thank you
im getting connection refused
This is 2yrs old,.. .we need an update of this same video but adding and integrating Liquibase please