From: | Victor Hugo <vh(dot)clemente(at)gmail(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Cannot establish a remote connection |
Date: | 2014-02-25 19:39:14 |
Message-ID: | CALMSkPUP4mnLQY3OpZvZwLvBTAxaX-vRZMqRMtXA+DrYrnjgVA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
I tell the firewall that is running on the database server. If linux, make
sure it is actually running, because I had problems with this SELINUX, edit
/ etc / selinux / config file. Find the line SELINUX=enforcing and replace
with SELINUX=disabled.
This will disable SELinux at the next reboot
Maybe that...
2014-02-25 15:18 GMT-03:00 JORGE MALDONADO <jorgemal1960(at)gmail(dot)com>:
> The DB server IP address is 192.168.168.2
> The client PC that tries to connect to DB server is 192.168.168.73
>
> As you can see, the 2 machines are in the same private network and same
> subnet.
> I assume that no firewall is needed in this case.
>
> Regards.
>
>
> On Tue, Feb 25, 2014 at 11:56 AM, Victor Hugo <vh(dot)clemente(at)gmail(dot)com>wrote:
>
>> What is the IP of the database server?
>> Have router between the database server and pgAdmin III ??? Is on the
>> same subnet ?
>> The firewall ports are enabled?
>>
>> Tk´s ;-)
>>
>>
>> 2014-02-25 14:20 GMT-03:00 JORGE MALDONADO <jorgemal1960(at)gmail(dot)com>:
>>
>> I need to connect to a remote PostgreSQL 9.3 database with pgAdmin III
>>> within our private network, so I did the following:
>>>
>>> * Open postgresql.conf file and verify that listen_addresses = '*'
>>> * Open pg_hba.conf and add the following line:
>>> host all all 192.168.168.0/24 md5
>>> Our private network segment is 192.168.168.*
>>> * I stop PostgreSQL service.
>>> * I start PostgeSQL service.
>>>
>>> I can connect locally but not remotely.
>>> I will very much appreciate your feedback.
>>>
>>> Respectfully,
>>> Jorge Maldonado
>>>
>>>
>>
>>
>> --
>> Abcs
>> Victor Hugo - DBA
>> Mobile: (21) 99529-5585
>> Google Talk: vh.clemente
>> Skype: vh.clemente
>>
>> "Antes de imprimir, pense em sua responsabilidade e compromisso com o
>> MEIO AMBIENTE"
>>
>
>
--
Abcs
Victor Hugo - DBA
Mobile: (21) 99529-5585
Google Talk: vh.clemente
Skype: vh.clemente
"Antes de imprimir, pense em sua responsabilidade e compromisso com o MEIO
AMBIENTE"
From | Date | Subject | |
---|---|---|---|
Next Message | VB N | 2014-02-25 22:41:44 | Re: Cannot establish a remote connection |
Previous Message | Victor Hugo | 2014-02-25 17:56:32 | Re: Cannot establish a remote connection |