Re: psqsl -> remote db

From: Gregory Youngblood <pgcluster(at)netio(dot)org>
To: Andrew Stewart <astew(at)wam(dot)umd(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: psqsl -> remote db
Date: 2005-08-04 18:53:00
Message-ID: FF737448-AB29-4928-ADA5-AB1041CBD16B@netio.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

What machine is remote? Linux? Solaris? or Mac? I couldn't tell if
the remote system or your workstation was a Mac.

I will assume the postgresql server is on a Mac, and that the Mac has
its firewall enabled. On my Mac, to open a firewall for something
like this, go to System Preferences, and then click Sharing. There
you should see a Firewall button - click to display the firewall
settings. Scroll through the Allow list and make sure there is not
already an entry for PostgreSQL. If there is, make sure it is
checked. If not, click the New... button. Enter a port name
("PostgreSQL"), and enter "5432" in the TCP Ports field. [I do not
believe postgresql uses UDP.] Click OK. Then make sure the PostgreSQL
port was added to the Allow list and is checked. Close System
Preferences, and answer Yes to save, if prompted. That should be it,
the mac should now allow incoming traffic on PostgreSQL's port.

If the remote computer is not a Mac, the instructions above will not
work.

Are you sure the remote postgresql server has been configured to
listen on port 5432 ? By default, postgresql often will not listen to
TCP connections unless explicitly instructed to do so. Depending on
how postgresql is installed, it could be that it just isn't listening
for a network connection, only allowing local connections.

On Aug 4, 2005, at 11:26 AM, Andrew Stewart wrote:

> I'm sorry, I'm sure I should be asking this someplace more general,
> but apparantly the word 'port' is used in so many different
> contexts that a google search turns up fruitless ;)
>
> I'm just trying to access a remote postgresql database on port
> 5432, which does not appear to be open on the remote computer. I'm
> on a MacOSX and cannot figure out for the life of me how to open
> up this port on the computer.
> This is probably a unix question if anything, but any help would be
> apprecaited.
>
> -Andrew
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message John D. Burger 2005-08-04 18:53:41 Re: psqsl -> remote db
Previous Message jcradock 2005-08-04 18:41:10 Re: psqsl -> remote db