Re: remote connection problem

Ilija,

Make a test change md5 to trust and see if you can connect.

Do not forget to restart the service

[]´s
Victor Hugo

2012/5/16 Ilija Vidoevski <ilija(at)fructal(dot)com(dot)mk>:
> I can not access to postgresql server 9.1.3 form client computer with
> front-end application written in MS Visual Foxpro 9 SP2.
>
>
>
> Application made connection when work on PC where is postgresql server
> installed.
>
>
>
> Connstr="DRIVER={PostgreSQL odbc
> driver(unicode)};server=localhost;Port=5432;Database=mydatabase;
> Uid=postgres;Pwd=mypwd;UseServerSidePrepare=1;MaxVarcharSize=254;UnknownsAsLongVarchar=0;TextAsLongVarchar=0;"
>
>
>
> I installed ODBC driver v 09.00.0310-1 on client PC. Also firewall is
> disabled on server side.
>
>
>
> This a settings in postgresql.conf file:
>
> listen_addresses = '*'
>
>
>
> This a settings in pg_hba.conf file:
>
> # IPv4 local connections:
>
> host     all       all       0.0.0.0/0         md5
>
> # IPv6 local connections:
>
> host     all       all       ::0/0    md5
>
>
>
> I got this message:
>
> Connectivity error: Could not connect to server;
>
> No connection could be made because the target machine actively refused it
> (127.0.0.1:5432)
>
>
>
> Any ideas what is wrong ?.
>
>
>
> Thank’s
>
> Ilija
>
>

--
[]´s
Victor Hugo

"Antes de imprimir, pense em sua responsabilidade e compromisso com o
MEIO AMBIENTE"