From: Bo Guo <bo.guo@gisticinc.com>
To: pgsql-admin@lists.postgresql.org
Subject: pgadmin4 container install: volume mapping not working
Date: Sun, 17 May 2020 12:30:39 -0700
Message-ID: <cadaa38d-ed36-d525-a30c-364de2398bc5@gisticinc.com> (raw)
In-Reply-To: <CAFWkJcEGALQ1q-WrnXfD5eN-EaqNS+me5hjn-4arJagFiGchqQ@mail.gmail.com>
References: <CAJ8oN=EvhvinhPBneC1f3Yc5c3GY2=w4uqQTo5zbgL1ytoCfBA@mail.gmail.com>
<CAFWkJcEGALQ1q-WrnXfD5eN-EaqNS+me5hjn-4arJagFiGchqQ@mail.gmail.com>
Hi list,
I have been using the docker container install of pgAdmin4 for about a
year and half, during which time I tried several times trying to make
volume mapping work, in vein.
Yes, the docker installation is very clean and simple. But I just could
not make volume mapping to work so that script file saved can be
accessed easily and server connections or any session related history
etc. can be preserved when updating to use the latest container images.
I hope someone can provide a pointer or two to help me.
Here is what I used to create the instance
docker run --name "pgadmin4.21" \
-p 5050:80 \
-e 'PGADMIN_DEFAULT_EMAIL=pgadmin@example.com' \
-e 'PGADMIN_DEFAULT_PASSWORD=123456' \
-d dpage/pgadmin4 \
-v /opt/pgadmin_session:/var/lib/pgadmin \
-v /opt/pgadmin_config:/pgadmin4
Docker Inspection shows the container having
"Env": [
"PGADMIN_DEFAULT_EMAIL=pgadmin@example.com",
"PGADMIN_DEFAULT_PASSWORD=123456",
"PATH=/usr/local/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin",
"LANG=C.UTF-8",
"GPG_KEY=0D96DF4D4110E5C43FBFB17F2D347EA6AA65421D",
"PYTHON_VERSION=3.7.7",
"PYTHON_PIP_VERSION=20.0.2",
"PYTHON_GET_PIP_URL=https://github.com/pypa/get-pip/raw/d59197a3c169cef378a22428a3fa99d33e080a5d/get-pip.py";,
"PYTHON_GET_PIP_SHA256=421ac1d44c0cf9730a088e337867d974b91bdce4ea2636099275071878cc189e",
"PYTHONPATH=/pgadmin4"
],
"Cmd": [
"-v",
"/opt/pgadmin_session:/var/lib/pgadmin",
"-v",
"/opt/pgadmin_config:/pgadmin4"
],
Before I start the container instance, I made sure the folders were
accessible
sudo mkdir /opt/pgadmin_session
sudo mkdir /opt/pgadmin_config
sudo chown 5050:5050 /opt/pgadmin_session
sudo chown 5050:5050 /opt/pgadmin_config
sudo chmod -R 777 /opt/pgadmin_session
sudo chmod -R 777 /opt/pgadmin_config
Cheers!
Bo
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: bo.guo@gisticinc.com, pgsql-admin@lists.postgresql.org
Subject: Re: pgadmin4 container install: volume mapping not working
In-Reply-To: <cadaa38d-ed36-d525-a30c-364de2398bc5@gisticinc.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox