LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Newbie (https://www.linuxquestions.org/questions/linux-newbie-8/)
-   -   How to connect Postgresql remotely? (https://www.linuxquestions.org/questions/linux-newbie-8/how-to-connect-postgresql-remotely-511840/)

monded 12-19-2006 02:20 AM

How to connect Postgresql remotely?
 
I have new setup a Postgresql , add the port 5432, local ping is ok,
but can't connect remotely...
anyone can help me please?

Vorik 12-19-2006 07:54 AM

It must be listening on all addresses (not just localhost)
and you must have a user that can connect from a remote location.

wmakowski 12-19-2006 03:46 PM

When you start up postmaster on the server be sure to add the -i option to the command line. The man page reads, "This enables TCP/IP or Internet domain socket communication. Without this option, only local Unix domain socket communication is possible."

Another step is to set up an entry in pg_hba.conf to allow the external host to connect. hba stand for Host Based Authentication.

Lastly, as Vorick mentioned, the user that connects must have access to the database they are connecting to.

Bill


All times are GMT -5. The time now is 01:57 AM.