Skip site navigation (1) Skip section navigation (2)

Re: Remote Connection to server: Connection Refused

From: Victor Hugo <vh(dot)clemente(at)gmail(dot)com>
To:
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Remote Connection to server: Connection Refused
Date: 2010-08-16 18:03:01
Message-ID: AANLkTi=wjazjhn8SyJpKMwMcXJu9_zBgyk5apDPcMkj=@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
Kavitha,

host all all  IP_you_network/24 md5

[]´s
Victor Hugo

2010/8/16 Kavitha Parvataneni <kavip81(at)yahoo(dot)com>:
>
> I am using Postgresql 8.4 on Ubunut 10.04
>
>
>
> I am having trouble connecting a remote client to the Postgresql server
> running on the Ubuntu 10.04 machine. I don’t have a problem opening a client
> connection on the host machine.
>
>
>
> I did the following changes :
>
>
>
> In Postgresql.conf file :
>
>
>
> listen_address = ‘*’
>
>
>
> In pg_hba.conf file:
>
>
>
> local  all   all                           md5
>
> host   all   all      0.0.0.0/0        md5
>
>
>
> I restarted the server after making these changes
>
>  sudo /etc/init.d/postgresql-8.4 restart
>
>
>
> The remote client and  the host(postgresql server) are on the same network .
> I can ping each other and they are communicating.
>
>
>
> I checked if the server is running using the command from the terminal
>
>
>
> sudo /etc/init.d/postgresql-8.4 status
>
>
>
> I got the following response:
>
>
>
> Running clusters: 8.4/main
>
>
>
> Please help me. What am I doing wrong?
>
> Thanks
>



-- 
[]´s
Victor Hugo

In response to

pgsql-novice by date

Next:From: Leon StarrDate: 2010-08-16 18:30:08
Subject: Re: How to trap invalid enum input exception?
Previous:From: Rikard BosnjakovicDate: 2010-08-16 18:01:55
Subject: Can I use check-constraint to set null?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group