We have Postgress Database running on machine with ip address 192.168.0.1 on port no 5432.
We want to access this database from outside the firewall. Hence we need to open port no 5432 of 192.168.01 in firewall for outside users. But in firewall configuration we need to provide the type of call also like https, https, ect.
We have Swing based application that need to access database over internet.
Please guild me, what kind of call it will be from Swing based application to database?
Jdbc uses TCP protocol for communicating with the database. So in the firewall you need to mention the destination IP and also the protocol which in this case is TCP. Also if you want to restrict it based on a particular external IP then you need to mention that in postgres.conf file (listen_addresses).