Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jaR65-0007iH-IA for pgsql-admin@arkaria.postgresql.org; Sun, 17 May 2020 21:45:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jaR62-0003qS-LD for pgsql-admin@arkaria.postgresql.org; Sun, 17 May 2020 21:45:22 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jaR62-0003pL-CL for pgsql-admin@lists.postgresql.org; Sun, 17 May 2020 21:45:22 +0000 Received: from jakobs.com ([85.214.83.89] helo=rs.plausibolo.de) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jaR5s-0003wS-M0 for pgsql-admin@lists.postgresql.org; Sun, 17 May 2020 21:45:21 +0000 Received: from localhost (localhost [127.0.0.1]) by rs.plausibolo.de (Postfix) with ESMTP id 09FBCBE080C for ; Sun, 17 May 2020 23:45:10 +0200 (CEST) X-Virus-Scanned: Debian amavisd-new at rs.plausibolo.de Received: from rs.plausibolo.de ([IPv6:::1]) by localhost (h2367442.stratoserver.net [IPv6:::1]) (amavisd-new, port 10024) with ESMTP id NqHPSB0wYA9x; Sun, 17 May 2020 23:45:06 +0200 (CEST) Received: from [192.168.178.91] (i59F6782F.versanet.de [89.246.120.47]) by rs.plausibolo.de (Postfix) with ESMTPSA id C560EBE01D7; Sun, 17 May 2020 23:45:06 +0200 (CEST) Subject: Re: pgadmin4 container install: volume mapping not working To: pgsql-admin@lists.postgresql.org References: From: Holger Jakobs Message-ID: <214afdbe-0a38-9b6b-5a6a-5427fe12e89d@jakobs.com> Date: Sun, 17 May 2020 23:45:06 +0200 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Thunderbird/68.7.0 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/alternative; boundary="------------74556757D5DB18628F62265A" Content-Language: de-DE List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------74556757D5DB18628F62265A Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit Please ask pgadmin4 questions on the mailing list of pgadmin4. This one is for postgresql itself. Am 17.05.20 um 21:30 schrieb Bo Guo: > > 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 > -- Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012 --------------74556757D5DB18628F62265A Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit

Please ask pgadmin4 questions on the mailing list of pgadmin4. This one is for postgresql itself.

Am 17.05.20 um 21:30 schrieb Bo Guo:

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

-- 
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
--------------74556757D5DB18628F62265A--