Thread: Unable to connect from other machine

Unable to connect from other machine

From
Mikko Heiskanen
Date:
Hi list,

I am having problems connecting to postgresql 7.4.7 server running on
Mac OS X,
from other machine running FreeBSD 5.4-release.
The program I'm using is pgAdmin III.
On my server configuration I have
pg_hba.conf:
host all all 10.0.0.33/24 trust

postgresql.conf:
tcpip_socket = true

I have restarted the server after changing the settings.

On the pgAdmin III's connection settings I have address and port
definitions right.
The username is only a postgresql user, not UNIX-environment user.
My tcp-wrappers are set to allow local network hosts.
What else could be affecting the connection?

TIA,
Mikko Heiskanen
(ps, I'm not subscribed)


Re: Unable to connect from other machine

From
tgoodaire@linux.ca (Tim Goodaire)
Date:
Does it say anything in the postgres logs when you try to connect? If
it's a pg_hba.conf problem, it'll tell you.

Tim

On Sat, May 14, 2005 at 05:56:24PM +0300, Mikko Heiskanen wrote:
> Hi list,
>
> I am having problems connecting to postgresql 7.4.7 server running on
> Mac OS X,
> from other machine running FreeBSD 5.4-release.
> The program I'm using is pgAdmin III.
> On my server configuration I have
> pg_hba.conf:
> host all all 10.0.0.33/24 trust
>
> postgresql.conf:
> tcpip_socket = true
>
> I have restarted the server after changing the settings.
>
> On the pgAdmin III's connection settings I have address and port
> definitions right.
> The username is only a postgresql user, not UNIX-environment user.
> My tcp-wrappers are set to allow local network hosts.
> What else could be affecting the connection?
>
> TIA,
> Mikko Heiskanen
> (ps, I'm not subscribed)
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>               http://archives.postgresql.org


Attachment