I have a PostGIS database setup in PostgreSQL on port 5432 on an AWS Windows server shared with Geoserver, which is running on port 8080. I can connect from Geoserver to the PostGIS database with no issues using "localhost" as the host. The server is on the public domain so I can access Geoserver from any computer outside of out AWS network with an address, for example: http://product.company.com.au:8080/geoserver/web.
I need to be able to access the PostGIS database from applications outside the network, specifically from GISCloud. When I try to connect to the database from GISCloud (using http://product.company.com.au as the host), I get the error "Test Failed: Sorry, but you cannot use 'localhost'".
I imagine that this is either a configuration setting in PostgreSQL, however I have tried a few of the changes shown in other similar posts without any luck.
Alternatively, is it just a case of opening the specific port and this will work?
Or is there more to it than that?