Re: connection problems - Mailing list pgsql-admin

From Tino Schwarze
Subject Re: connection problems
Date
Msg-id 20080401145652.GE28379@easy2.in-chemnitz.de
Whole thread Raw
In response to connection problems  ("Shavonne Marietta Wijesinghe" <shavonne.marietta@studioform.it>)
List pgsql-admin
On Tue, Apr 01, 2008 at 04:44:29PM +0200, Shavonne Marietta Wijesinghe wrote:

> I have my postgresql(ver. 8 ) db on one computer (as localhost) and i'm trying to access it from another computer but
iget the error 
> "could not connect to Server: Connection refused"
>
> I followed the guide and changed the listen_address in the postgresql.conf file
> listen_addresses='*'
>
> and in the pg_hba.conf file I added the IP address of the pc i'm using
> host all all 192.168.X.X/32 trust
>
> But i get the same error. What should i do??

Did you restart the postmaster after setting listen_addresses?
Does netstat -tln display the appropiate port listening on *:5432 (or
whatever your port number is)?

Tino.

--
„Es gibt keinen Weg zum Frieden. Der Frieden ist der Weg.” (Mahatma Gandhi)

www.craniosacralzentrum.de
www.forteego.de

pgsql-admin by date:

Previous
From: "Shavonne Marietta Wijesinghe"
Date:
Subject: connection problems
Next
From: "Shavonne Marietta Wijesinghe"
Date:
Subject: Re: connection problems