From: Tino Schwarze <postgresql@tisc.de>
To: pgsql-admin@postgresql.org
Subject: Re: connection problems
Date: Tue, 1 Apr 2008 16:56:52 +0200
Message-ID: <20080401145652.GE28379@easy2.in-chemnitz.de> (raw)
In-Reply-To: <00c901c89406$e497d710$0602a8c0@DREAM>
References: <00c901c89406$e497d710$0602a8c0@DREAM>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: postgresql@tisc.de
Subject: Re: connection problems
In-Reply-To: <20080401145652.GE28379@easy2.in-chemnitz.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox