marcelo-ochoa / pgadmin4-docker-extension Goto Github PK

Hi, i am trying to add external server with SSH and for an unknown reason it tries to connect to localhost (but tunnel host is an external IP).
Probably, this issue happens because the host in connection tab is not an IP.

Servers without SSH are connected properly

Once I defined a server to an existing postgres server instance yet running in docker and defined a background color:

I cannot change that anymore. Do I something wrong?

Hi,

Thanks for the work on the PGAdmin extension. I loaded the extension on Docker Desktop, and it showed this:

As a fellow dev, it might be difficult to diagnose this without logs, if you let me know where they are, I'd be happy to do my part.

Is it possible to connect to Postgres running on localhost? In actual fact, I am running Postgres in Kubernetes Docker Desktop and have port forwarding so if there is a better way to connect within the Docker network that would also be fine.

Thanks,
Si

When in dark mode I cannot see the icon in Docker Desktop:

Hello :-)

It seems impossible to save any files via the "save file" dialog.
Is this by design or am I just missing something?

Steps to reproduce:

1. establish connection to any server, open a database and open the query tool

2. write some text

3. klick on the save icon
   

4. give a file name and klick save
   

5. message window shows a permission denied error
   

I also noticed that there is no home folder for pgadmin

My configuration:

• latest Docker on Windows 11

Your support is greatly appreciated

When I try and install the plugin through the marketplace, I get the following error:

Extension was not installed. Reason: installation could not be completed due to:
executing 'C:\Program Files\Docker\Docker\resources\bin\docker --context desktop-linux compose -p mochoa_pgadmin4-docker-extension-desktop-extension -f C:\Users\USERNAME\AppData\Roaming\Docker\extensions\mochoa_pgadmin4-docker-extension\vm\docker-compose.yml up -d' : exit status 1:
Network mochoa_pgadmin4-docker-extension-desktop-extension_default
Creating Network mochoa_pgadmin4-docker-extension-desktop-extension_default
Created Volume "mochoa_pgadmin4-docker-extension-desktop-extension_pgadmin_data"
Creating Volume "mochoa_pgadmin4-docker-extension-desktop-extension_pgadmin_data"
Created Container mochoa_pgadmin4-docker-extension-desktop-extension-pgadmin4-docker-extension-1
Creating Container pgadmin4_embedded_dd_vm Creating Container pgadmin4_embedded_dd_vm
Created Container mochoa_pgadmin4-docker-extension-desktop-extension-pgadmin4-docker-extension-1
Created Container pgadmin4_embedded_dd_vm
Starting Container mochoa_pgadmin4-docker-extension-desktop-extension-pgadmin4-docker-extension-1
Starting Container mochoa_pgadmin4-docker-extension-desktop-extension-pgadmin4-docker-extension-1
Started Error response from daemon: Ports are not available: exposing port TCP 0.0.0.0:59080 -> 0.0.0.0:0: listen tcp 0.0.0.0:59080: bind: An attempt was made to access a socket in a way forbidden by its access permissions.

I don't have anything else running on that port.
Docker Desktop 4.24.2

Hi!

Is there any way to backup to my local host system?

I'm running Docker Desktop on MacOS with pgAdmin4-Docker-Extension installed and I need to backup my database to my Mac but I can't find any way to mount to my host system. Is this even possible? If so, how?

This also applies to the other way around. I quiet often get databases from our customers and I need to restore them into my development environment. But I couldn't find a way to access a backup file from my host computer.

Thank you for your answer.

Only accessible area is the docker container's /tmp directory. How would one access the "virtual directory" or shared location that has been configured in the docker configs locally?

Where can I save, for example, queries?
All folders seems write protected.

After running a query and trying to copy the data output using the copy button in the UI I get a small message stating "Does not have clipboard access".
I would be nice to be able to do that.

I'm trying to access the extension inside docker and when it spins up it opens a blank white page.

CONTRIBUTING.md is a must read file for a new contributor in any repository before starting to work.

• Add general good practices while starting to work with this specific project.
• Add standard Github workflow commands in the CONTRIBUTING.md (opening issues, get assigned, fork, create clone, add, commit, creating PRs).
• It will provide new potential project contributors with a short guide to how they can help with your project.

Hi,
I cannot start the extension on my machine:

• Windows 11
• Docker Desktop 4.15.0
• PGAdmin4-docker-extension 6.17.0

Note: it works on mac

When opening the extension, I receive this message:

PGAdmin4 failed to start, please close the extension and reopen/reinstall to try again.

Debugging:

I have opened debugger using docker extension dev debug mochoa/pgadmin4-docker-extension. This is the error:

• cmd: "docker exec mochoa_pgadmin4-docker-extension-desktop-extension-pgadmin-1 python3 -c "import sqlite3;c=sqlite3.connect('/var/lib/pgadmin/pgadmin4.db');u=c.cursor();u.execute('insert or replace into user_preferences (pid,uid,value) values ((SELECT id from preferences where name=?),1,?)',('theme','dark'));c.commit();u.close();c.close()" || true"
• stderr: "Traceback (most recent call last):\n File "", line 1, in \nsqlite3.IntegrityError: NOT NULL constraint failed: user_preferences.pid\n'true' is not recognized as an internal or external command,\r\noperable program or batch file.\r\n"

Hi,
I'm runnig the extension in Docker Desktop on Windows 10 Pro 22H2..

Actually I can start the extension, running v4 6.19. Docker desktop is showing an update, but when I try to update via CLI ,it fails

executing 'docker --context desktop-linux compose -p mochoa_pgadmin4-docker-extension-desktop-extension down --remove-orphans' : exit status 1:
unable to resolve docker endpoint: unexpected end of JSON input

The same when I try to uninstall, though it is calling the same command.

Any ideas how to force removal/update ?

Thx,
Holger

Image not available locally, pulling mochoa/pgadmin4-docker-extension:8.1.0...
Extracting metadata and files for the extension "mochoa/pgadmin4-docker-extension:8.1.0"
Installing service in Desktop VM...
Setting additional compose attributes
Installing Desktop extension UI for tab "PGAdmin4"...
Extension UI tab "PGAdmin4" added.
Starting service in Desktop VM......
failed when running compose up for extension mochoa/pgadmin4-docker-extension:8.1.0: executing '/Applications/Docker.app/Contents/Resources/bin/docker --context desktop-linux compose -p mochoa_pgadmin4-docker-extension-desktop-extension -f extensions/mochoa_pgadmin4-docker-extension/vm/docker-compose.yml up -d' : exit status 1: 
 Network mochoa_pgadmin4-docker-extension-desktop-extension_default  Creating
 Network mochoa_pgadmin4-docker-extension-desktop-extension_default  Created
 Volume "mochoa_pgadmin4-docker-extension-desktop-extension_pgadmin_data"  Creating
 Volume "mochoa_pgadmin4-docker-extension-desktop-extension_pgadmin_data"  Created
 Container mochoa_pgadmin4-docker-extension-desktop-extension-service  Creating
 Container pgadmin4_embedded_dd_vm  Creating
 Container mochoa_pgadmin4-docker-extension-desktop-extension-service  Created
 Container pgadmin4_embedded_dd_vm  Created
 Container mochoa_pgadmin4-docker-extension-desktop-extension-service  Starting
 Container pgadmin4_embedded_dd_vm  Starting
 Container mochoa_pgadmin4-docker-extension-desktop-extension-service  Started
Error response from daemon: Ports are not available: exposing port TCP 0.0.0.0:59080 -> 0.0.0.0:0: listen tcp 0.0.0.0:59080: bind: address already in use

executing '/Applications/Docker.app/Contents/Resources/bin/docker --context desktop-linux compose -p mochoa_pgadmin4-docker-extension-desktop-extension -f extensions/mochoa_pgadmin4-docker-extension/vm/docker-compose.yml up -d' : exit status 1: 
 Network mochoa_pgadmin4-docker-extension-desktop-extension_default  Creating
 Network mochoa_pgadmin4-docker-extension-desktop-extension_default  Created
 Volume "mochoa_pgadmin4-docker-extension-desktop-extension_pgadmin_data"  Creating
 Volume "mochoa_pgadmin4-docker-extension-desktop-extension_pgadmin_data"  Created
 Container mochoa_pgadmin4-docker-extension-desktop-extension-service  Creating
 Container pgadmin4_embedded_dd_vm  Creating
 Container mochoa_pgadmin4-docker-extension-desktop-extension-service  Created
 Container pgadmin4_embedded_dd_vm  Created
 Container mochoa_pgadmin4-docker-extension-desktop-extension-service  Starting
 Container pgadmin4_embedded_dd_vm  Starting
 Container mochoa_pgadmin4-docker-extension-desktop-extension-service  Started
Error response from daemon: Ports are not available: exposing port TCP 0.0.0.0:59080 -> 0.0.0.0:0: listen tcp 0.0.0.0:59080: bind: address already in use

Removing extension mochoa/pgadmin4-docker-extension:8.1.0...
Removing extension containers...
Extension containers removed
VM service socket forwarding stopped
Extension UI tab PGAdmin4 removed
Extension image mochoa/pgadmin4-docker-extension:8.1.0 removed
Extension "Open Source management tool for PostgreSQL" removed

Can you use the next available port? I am not sure if it is possible.
Or any configuration before starting?

Installed the plugin in docker，it‘s option in docker dashboard only, How to visit pgAdmin4 docker extension server in external browser？
tks!