Run a postgres container and connect with pgadmin (in another container)

build-environment.md

Start a postgres server:

docker run -v postgres:/var/lib/postgresql/data --name postgres-test -e POSTGRES_PASSWORD=mysecretpassword -d postgres

Start pgadmin

Connect with a one-off docker container in current process:

docker run -v pgadmin4:/home/pgadmin/.pgadmin -p 5050:5050 --link postgres-test:postgres-test --rm meedan/pgadmin

Connect with a persistant docker container as background process:

docker run -v pgadmin4:/home/pgadmin/.pgadmin -p 5050:5050 --link postgres-test:postgres-test --name pgadmin -d meedan/pgadmin

You can stop with docker stop pgadmin and restart with docker start pgadmin. Just make sure the postgres container is running as well.

Connect to DB

Open http://localhost:5050. Add server, and use postgres as hostname, postgres as user, and mysecretpassword as password.

PGADMIN_USER for user name (default value is [email protected])
PGADMIN_PASSWORD for password (default value is pgadmin)

Very cool, but it says your pgadmin is out of date

Thanks for the interest. This gist is a little out of date, though it should still work if you use the correct hostname as noted by @asfilo, and you login with the default email and password noted by @mungale.

I'll create and upload a new gist in the future if or when I start using this approach again, but for the time being I use the pgadmin available in the Ubuntu Apt repositories.

Now you can use --network parameter or so. Look at here.

@hakuno Thanks! I'll keep that in mind if I start using this again. If this is something you use regularly, please feel free to write a new gist or fork this one, and I'll update this one to link to it.

(Off-topic: Thank you Github for finally making gist comments notify me!)