Re: connection problems

From: Tino Schwarze <postgresql(at)tisc(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: connection problems
Date: 2008-04-01 14:56:52
Message-ID: 20080401145652.GE28379@easy2.in-chemnitz.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 i get 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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Shavonne Marietta Wijesinghe 2008-04-01 15:52:01 Re: connection problems
Previous Message Shavonne Marietta Wijesinghe 2008-04-01 14:44:29 connection problems