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