Re: Remote connection issue

Поиск
Список
Период
Сортировка
От Pushpendra Singh Thakur
Тема Re: Remote connection issue
Дата
Msg-id CAH55RCFUH-QykP0bmSyaMGHDoSChwqwxaNzKES=TEB5wfeSa+A@mail.gmail.com
обсуждение исходный текст
Ответ на Remote connection issue  (Nomeneta Saili <nome.saili@gmail.com>)
Список pgsql-novice
If you are convinced that it isn't the firewall then just to test put this into your pg_hba :
host all all 0.0.0.0/32 md5


On 8 February 2012 03:04, Nomeneta Saili <nome.saili@gmail.com> wrote:
Hi list,

I am having remote connection issue to my postgres/postgis database. When i try to connect it gives me this error

"Server doesn't listen
The server doesn't accept connections: the connection library reports 
could not connect to server: Connection timed out (0x0000274C/10060) Is the server running on host "10.10.1.6" and accepting TCP/IP connections on port 5432? 

The port 5432 is opened on my server firewall form both inbound and outbound (Windows Server 2008)

The postgres server is running on my server and i am able to access my tables locally.

There is no network connection issue and i tried ping and it was successful. 

Password and other account details correct. 

The postgresql.config file is already set to listen to all ip in " listen_addesses * " 

My client PC ip address in particular is also included in the pg_hba.confg file with these parameters "host    all         all        10.10.1.203/32         trust"

I turned off my Kaspersy anti-virus just to check it it might be it blocking the connection.

I already rebooted my server and client PC.

I already tested connection on another client PC closer to the server running my postgres server.

None work.

Connection was working in the morning and then it wasn't in the afternoon. There were no hardware or software update.

Does anyone have any other ideas where else i can look?. 

Any advice is much appreciated

Thanks

Nome 




--
Pushpendra Singh Thakur
COREEXPERTS Technologies Private Limited
Process Automation Services
http://www.corexprts.com
Phone - 9039024254
Fax - 91-761-4010530

This message may contain confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version.

В списке pgsql-novice по дате отправления:

Предыдущее
От: Nomeneta Saili
Дата:
Сообщение: Remote connection issue
Следующее
От: Carlos Mennens
Дата:
Сообщение: Two Tables That Share Data?