Re: Remote connection issue

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(dot)saili(at)gmail(dot)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.*
*