Обсуждение: pgAdmin4 stopped working with VPN upon upgrade.
I run pgAdmin4 in an Ubuntu VM.
I connect to a PostgreSQL database running on AWS RDS.
To connect to RDS, I run an OpenVPN to AWS.
On my host OS, I run a VPN from my Windows virus software vendor for general privacy.
All of this worked fine until today when I upgraded to pgAdmin4 5.6 using apt.
Now I have to disconnect the VPN on my host OS.
With the host OS VPN up, expanding a table on the tree navigation (and sometimes before I drill down that far) hangs.
I have to bring down the host OS VPN, and restart pgAdmin4 for it to start working again.
I tried to find a way to downgrade pgAdmin4, but couldn't find how to do this with apt. I tried to uninstall and then install specifying the version, but I got this:
~$ sudo apt install pgadmin4=5.5Reading package lists... DoneBuilding dependency treeReading state information... DoneSome packages could not be installed. This may mean that you haverequested an impossible situation or if you are using the unstabledistribution that some required packages have not yet been createdor been moved out of Incoming.The following information may help to resolve the situation:The following packages have unmet dependencies:pgadmin4 : Depends: pgadmin4-server (= 5.5) but 5.6 is to be installedDepends: pgadmin4-desktop (= 5.5) but 5.6 is to be installedDepends: pgadmin4-web (= 5.5) but 5.6 is to be installedE: Unable to correct problems, you have held broken packages.
Can someone advise me?
I'm looking for either a way to downgrade pgAdmin using apt, or a way to configure my connections in pgAdmin4 to tolerate using my host OS VPN.
Hi,
On Wed, Aug 18, 2021 at 4:23 AM Rick K6y <rick.k6y@gmail.com> wrote:
I run pgAdmin4 in an Ubuntu VM.I connect to a PostgreSQL database running on AWS RDS.To connect to RDS, I run an OpenVPN to AWS.On my host OS, I run a VPN from my Windows virus software vendor for general privacy.All of this worked fine until today when I upgraded to pgAdmin4 5.6 using apt.Now I have to disconnect the VPN on my host OS.With the host OS VPN up, expanding a table on the tree navigation (and sometimes before I drill down that far) hangs.I have to bring down the host OS VPN, and restart pgAdmin4 for it to start working again.
No major changes done in this area in the latest release.
Please provide some details:
- Are you running pgAdmin in Web mode or Desktop mode?
- Do you see any error in browser console or in pgAdmin logs?
- Can you please clear session files located at /var/lib/pgadmin4/sessions folder, restart the apache server and try it again?
Thanks,
Khushboo
I tried to find a way to downgrade pgAdmin4, but couldn't find how to do this with apt. I tried to uninstall and then install specifying the version, but I got this:~$ sudo apt install pgadmin4=5.5Reading package lists... DoneBuilding dependency treeReading state information... DoneSome packages could not be installed. This may mean that you haverequested an impossible situation or if you are using the unstabledistribution that some required packages have not yet been createdor been moved out of Incoming.The following information may help to resolve the situation:The following packages have unmet dependencies:pgadmin4 : Depends: pgadmin4-server (= 5.5) but 5.6 is to be installedDepends: pgadmin4-desktop (= 5.5) but 5.6 is to be installedDepends: pgadmin4-web (= 5.5) but 5.6 is to be installedE: Unable to correct problems, you have held broken packages.Can someone advise me?I'm looking for either a way to downgrade pgAdmin using apt, or a way to configure my connections in pgAdmin4 to tolerate using my host OS VPN.