Re: remote connection problem - Mailing list pgsql-novice

Hi

On 17 May 2012 09:28, Ilija Vidoevski <ilija@fructal.com.mk> wrote:
> Thank's Michael.
>
> How can I be so blind. Connection is made.

Good.

> But speed through LAN is disaster.
> On the PC where postgresql server is installed, postgre is little slower
> then MS SqlSerever 2008 r2 express (same tables, same indexeses, same
> query).
>
> But when I run app on client PC retrieving data from server is very, very
> slow. On server PC report finish  for 2-3 sec, but on client PC about 1 min.
>
> On the server is also installed MS SqlSerever 2008 r2 express, and there is
> not great differences in speed to get data (from server or client PC). From
> server PC 1-2 sec and from client PC 2-4 sec.

Perhaps someone on the list will have an idea of why this might be.
I've copied the list in my reply.

> Ilija
> -----Original Message-----
> From: Michael Wood [mailto:esiotrot@gmail.com]
> Sent: Wednesday, May 16, 2012 11:26 PM
> To: Ilija Vidoevski; pgsql-novice@postgresql.org
> Subject: Re: [NOVICE] remote connection problem
>
> Sorry for top posting. Replying from my phone and it does not allow
> any other option. If I understand you correctly it works when you run
> it on the same machine as the database server, but not when the client
> is a different machine from the server? If that is the case then you
> have specified the wrong host name in your connection string.
> Localhost means "this machine". i.e. the machine that the client is
> running on. So if you want to connect to another machine you must
> specify that machine's name or address instead of localhost.
>
> On 5/16/12, Ilija Vidoevski <ilija@fructal.com.mk> wrote:
>> 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;UnknownsAsL
>> ongVarchar=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

--
Michael Wood <esiotrot@gmail.com>