Re: psqsl -> remote db

jcradock(at)me3(dot)com wrote:

>First, makes sure the PostgreSQL database is listening for TCP/IP
>connections on the computer you're trying to connect to. On Mac OS X, run
>this command in the a terminal, i.e. Terminal.app:
>
>netstat -l
>
>You should see a line like this somewhere in the output:
>
>tcp6 0 0 *.5432 *.* LISTEN
>
>Second, the database server's pg_hba.conf likely needs to be configured to
>accept connections from remote users. This can be done to restrict
>connections from specific hosts (IP addresses), which isn't terribly
>practical, or by user and encrypted password. Search the PostgreSQL
>document site for "pg_hba.conf" for info.
>
>Third, if the database server is listening, and it is configured to allow
>you to connect, try connecting with psql:
>
>psql -h myhost.com -U me mydb
>
>"myhost.com" can be an IP address. Type "man psql" to see what the options
>mean.
>
>I hope this helps.
>
>Jim
>
>
>
>>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
>>
>>
>>
I'm not a Mac user, but don't they have a firewall by default?

Maybe useful?

http://cfm.gs.washington.edu/security/firewall/osx-10.1-ipfw/

--
****************************
Daniel Armbrust
Biomedical Informatics
Mayo Clinic Rochester
daniel.armbrust(at)mayo.edu
http://informatics.mayo.edu/