Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Postgres and Firewall

 
Chetan Parekh
Ranch Hand
Posts: 3640
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
JavaRanch feeder
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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).
 
Chetan Parekh
Ranch Hand
Posts: 3640
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks for your reply.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic