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...
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
In response to
pgsql-general by date
|Next:||From: Owen Hartnett||Date: 2008-11-30 04:40:44|
|Subject: Question on libpq parameters|
|Previous:||From: Scott Marlowe||Date: 2008-11-30 00:20:04|
|Subject: Re: db backup script in gentoo|