Re: Remote Connection

[Andrew Gould <andrewlylegould@xxxxxxxxx>]

On Thu, Feb 12, 2009 at 5:04 PM, Bob Pawley <rjpawley@xxxxxxx> wrote:

Hi

 

I've been operating on localhost successfully for some time.

 

I am now attempting to access a Postgresql 8.3 database installed on one of my other computers conneted through a router.

 

Is this possible?

 

My first attempts have been with Postgresql Admin.

 

I changed host to the IP address of the computer and input the other info.

 

I also ran - listen virtual; on the receiving server.

 

It hasn't connected successfully. I get the message 'Server not listening'

 

What else can I do??

 

Bob

 

  1.  Configure pg_hba.conf to allow access from your network, internet, etc, as appropriate.
  2.  If you're accessing the database from outside of your network, across a NAT, ensure that your router forwards port 5432 to your database server.
  3.  Ensure that port 5432 is not blocked by your firewalls.

Best of luck,

Andrew