LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Software (https://www.linuxquestions.org/questions/linux-software-2/)
-   -   postgres - query from 9.x client to a 8.x server hangs (https://www.linuxquestions.org/questions/linux-software-2/postgres-query-from-9-x-client-to-a-8-x-server-hangs-944453/)

eantoranz 05-11-2012 02:16 PM

postgres - query from 9.x client to a 8.x server hangs
 
Hi!

I'm having this problem that seems a little odd. I am running a query from pgsql, pgadmin3 (using pg9 libreries) against a pg8 server. The query, when run from other places runs normally (like, in less than a second you get the results) but when running from this box, the query never ends (well... maybe not never, I just kill the client after 10 minutes without a response). Could it be the difference in library versions the cause of this behavior?

Thanks in advance.

michaelk 05-14-2012 10:24 PM

I would not expect any issues with different versions. I do not have any problems running simple queries with either pgsql 9.1.3 or pgAdmin3 version 1.14.0 connecting to a 8.4 server. Difficult to troubleshoot since we can not duplicate your exact setup.


All times are GMT -5. The time now is 03:25 PM.