Re: Install question on Mac Leopard Server 10.5

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