Pgadmin Environment Variables

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:

2020-09-29 13_54_02-cmd

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.

2020-09-29 13_55_27-cmd

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.

About way0utwest

Editor, SQLServerCentral
This entry was posted in Blog and tagged , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.