| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Enrico <sscotty71(at)gmail(dot)com>, pgsql-odbc(at)postgresql(dot)org |
| Subject: | Re: Odbc through vpn |
| Date: | 2015-03-20 14:07:03 |
| Message-ID: | 550C2987.5050405@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
On 03/19/2015 03:01 AM, Enrico wrote:
> Hi, I did a migration from postgresql 8.1 to 9.4.1 and I have this problem, only for clients who work through the vpn, queries are very slow and this problem did not exist before migration,the network is the same , the server is the same, the current version of postgresql is 9.4.1 and odbc is the latest 32-bit version.
> For the clients who work in LAN , ODBC works fine.
>
> Can anyone help me?
To be clear and get more information:
1) What OSes are you using for clients, server?
2) You upgraded from Postgres 8.1 --> 9.4.
3) You say you are using latest 32 bit version of ODBC, so was that
upgraded at the same time?
4) What is the exact version of the ODBC driver you are using?
5) What happens if you run the queries remotely without going through ODBC?
Wonder if it is related to this thread about SSL compression?:
>
> Thanks in advantage.
>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Enrico Pirozzi | 2015-03-20 14:49:40 | Re: Odbc through vpn |
| Previous Message | Kadri Raudsepp | 2015-03-20 11:38:03 | Problem with client_encoding and PsqlODBC driver. |