Hi all! Would like to allow my application to connect to the PostgreSQL, I am using Zeoslib and have tried to configure the firewall but no success. Also the pg_hba.conf. How should be the correct configuration to pg_hba.conf that could allow my client application to connect to my database?
Thank you
Allow my app to connect via internet
Moderators: gto, cipto_kh, EgonHugeist, olehs
Postgres over the internet.
Hi Shomar,
You don't say how you are connecting across the internet. You need to make sure tha you have a route configured between the client and server. Have you got your gateway addresses set correctly, if you are using a proxy have you got the correct proxy type configured and using the correct user name/password. Is the server PC on a LAN. If so, do you have the port 5432 mapped from your internet connection to the server pc. If you have everything configured correctly you should be able to telnet on port 5432 to the server (when the postgres server is running).
Gerard
You don't say how you are connecting across the internet. You need to make sure tha you have a route configured between the client and server. Have you got your gateway addresses set correctly, if you are using a proxy have you got the correct proxy type configured and using the correct user name/password. Is the server PC on a LAN. If so, do you have the port 5432 mapped from your internet connection to the server pc. If you have everything configured correctly you should be able to telnet on port 5432 to the server (when the postgres server is running).
Gerard
Re: Allow my app to connect via internet
Hi Shomar,
have u been able to solve ur problem here ?If not, would u mind sharing us ur internet access topology so we could get some better view of ur problem for an accurate solution.
have u been able to solve ur problem here ?If not, would u mind sharing us ur internet access topology so we could get some better view of ur problem for an accurate solution.