I’ve had to do some work on PostgreSQL, and I wrote an article at SQLServerCentral about getting started. Once I had things working, and could connect from Azure Data Studio(ADS), I also wanted to get pgadmin working in a container for admin tasks.
I downloaded the container and ran it with this:
docker container run -p 5050:5050
-e 'PGADMIN_DEFAULT_EMAIL=sjones@sqlservercentral.com'
-e 'PGADMIN_DEFAULT_PASSWORD=Str0ngPwd!'
--name="pgadmin4" --hostname="pgadmin4" -d dpage/pgadmin4
However, when I checked status, it would always be down. When I checked the logs (docker container logs pgadmin4), I’d see this:
Ugh. I kept looking through docs and checking different posts. Lots of different options with quotes that I kept trying, but eventually when I went with double quotes, things worked.
Leaving off the –d let me see this was actually starting up.
This was on Docker for Windows, with Linux containers for me.
I would swear that I tried just double quotes before this, but I bet I kept adding single quotes and double quotes in different ways, like this:
docker container run -p 5050:5050
-e 'PGADMIN_DEFAULT_EMAIL="sjones@sqlservercentral.com"'
-e 'PGADMIN_DEFAULT_PASSWORD="Str0ngPwd!"'
--name="pgadmin4" --hostname="pgadmin4" -d dpage/pgadmin4
In any case, I got it working. I couldn’t connect for some reason to the PostgreSQL server, but that’s for another post.