Steve Henry wrote:
I am just getting started with PostgreSQL. I've installed PostgreSQL
8.3.5-1 on a MacPro server running Leopard Server 105.5
I can connect to the database with PGAdmin on the server, but I can't
access the database from another Mac on my network. I get the following
error message:
I've done the following:
- checked the postgresql.conf file for listen_addresses, it's set to
'*'
This will most likely be fine unless you have a complex network setup
- modified the pg_hba.conf file to allow traffice from the network
in my office.
You will find pg_hba.conf in the data folder. You need a line in this
file that allows connections from your clients ip addresses something like -
# TYPE DATABASE USER CIDR-ADDRESS METHOD
host all all 192.168.1.0/24 md5
The file itself has plenty of info.
- made sure my OS X Server Firewall has a hole for the port to be used.
If you have missed this then you need to open port 5432 on your firewall.
What am I missing? Any help would be greatly appreciated...
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
