I am currently trying to host Retool on an Amazon Lightsail server and connect it through a vpn to my database, but am having trouble configuring it to do so. Anyone have experience doing this sort of thing?
Edit 1: The error I receive upon hitting the "Test Connection" button in the Retool "Add Resource" Screen is as follows
Test connection failed. getaddrinfo ENOTFOUND [server hostname] The hostname you provided doesn't work. Perhaps there's a typo, or it's not a public hostname? (e.g. behind a VPC)
When hosted locally on my computer that was connected to the VPN as opposed to the LightSail server, I was able to query my database.
After using openconnect to connect to my VPN on the LightSail server, I was able to ping the Postgres server by running