Thread: Ssh tunnel hosts changing...
I have a bunch of servers defined in pgAdmin that all point at a particular ssh tunnel host. Well, the host that the tunnels go through now needs to change, so I need to update all the server properties.
Is there some way to do that without having to select each server and then properties and then the ssh tunnel tab? I had hoped that there would be a disk file or directory of files for each server, that contained all the settings, but then realize that the master password probably encrypts that file/files if they exist.
Is there another simpler way to make this update to all (most) of my servers?
Thanks,
Mike
Hi Mike
You can edit the Server table within the pgadmin4.db file, which is a SQLite database containing all pgAdmin4 configurations.
On Mon, Apr 22, 2024 at 1:17 PM Mike Peck <mike.peck@theonevalley.com> wrote:
I have a bunch of servers defined in pgAdmin that all point at a particular ssh tunnel host. Well, the host that the tunnels go through now needs to change, so I need to update all the server properties.Is there some way to do that without having to select each server and then properties and then the ssh tunnel tab? I had hoped that there would be a disk file or directory of files for each server, that contained all the settings, but then realize that the master password probably encrypts that file/files if they exist.Is there another simpler way to make this update to all (most) of my servers?Thanks,Mike