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.

Login page ask for email, and no email is set can you tell me how to log-in?

PGADMIN_USER for user name (default value is admin@pgadmin.org)
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!)