There is client infrastructure containing two servers - server1 (files), server2 (database - postgreSQL). We have direct access to the server1 (ftp/ssh). Server2 is not accessible directly, only from server1 and only for database connections (so no ftp/ssh access). Is there some solution, how to connect pgadmin from localhost to server2 in this configuration (by using that intermediate server1)? We are using this tool because it is desktop tool and has some advantages to phppgadmin (no memory limit, ...).
Classic ssh tunnel works only to server1, but I cannot connect it to server2 thru server1. Maybe some configuration, or script would be needed on server1?
Thanks for your help