Обсуждение: Problem with pgadmin4 : displaying data in the query editor
I installed "pgadmin4" (version 4.20 for Window 10 64 bits). With this app, I connect without worry to the PostgreSQL database that I installed on a virtual machine (PostgreSQL 11 and VM under Debian 10 installed in VirtualBox).
But although I can visualize the data contained in my PostgreSQL database from Windows with Putty or with Qgis (for geolocated data), I can't visualize them with "pgadmin4" in the query editor .
Previously, I was using pgadmin III and I didn't have this problem. I went around the parameters of "pgadmin4" and looked on the web, but I did not find anything to solve this problem.
Does anyone can help me ?
Thank you.
Hello,
I installed "pgadmin4" (version 4.20 for Window 10 64 bits). With this app, I connect without worry to the PostgreSQL database that I installed on a virtual machine (PostgreSQL 11 and VM under Debian 10 installed in VirtualBox).
But although I can visualize the data contained in my PostgreSQL database from Windows with Putty or with Qgis (for geolocated data), I can't visualize them with "pgadmin4" in the query editor .In the query editor of "pgadmin4", when I make a "SELECT" query, the "Data" tab returns nothing.However on the "message" tab I have a message telling me that the request has been executed. Here is a message for one of my tables: "Successful execution. Total time: 574 msec. 2780 lines affected.".Also under pgadmin4, the other SQL commands work well (create, insert, update, delete ....)
Previously, I was using pgadmin III and I didn't have this problem. I went around the parameters of "pgadmin4" and looked on the web, but I did not find anything to solve this problem.
Does anyone can help me ?
Thank you.
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
Please ask pgadmin4 questions on the mailing list of pgadmin4. This one is for postgresql itself.
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