Run psql in docker exec docker exec -ti NAME_OF_CONTAINER psql -U YOUR_POSTGRES_USERNAME
Category: postgresql
This requires a different image in Docker. You can’t just use the postgres image and create an extension in it. Instead, you have to use the postgis image. This image will have a database in it already setup for you to use with postgis. If…
This is a super simple way to retain the data and settings that you create and change on your PostgreSQL Docker instance. There’s a lot of talk about attaching databases after you recreate your Docker container, but I found that it’s easier to have persistent…
I used to freak out each time (and especially the first time) I upgraded pgadmin on my local computer. What happened to my saved servers list?!? Of course, I could recreate it because I have a listing of all the servers in Confluence, but ugh…