Unix Technical Forum

Re: Slow connections from Windows to Linux

This is a discussion on Re: Slow connections from Windows to Linux within the pgsql Interfaces Pgadmin Support forums, part of the PostgreSQL category; --> Ok, I was too quick : the problem appears not during the connection but when I open a database ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Interfaces Pgadmin Support

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-17-2008, 08:14 PM
Jacques Le Roux
 
Posts: n/a
Default Re: Slow connections from Windows to Linux

Ok, I was too quick : the problem appears not during the connection but when I open a database (or perhaps also when I refresh one ?). This problem does not appear when I'm using a 8.1 database locally (on a Windows 2000 machine) or not (on a "remote" Win Xp machine).

As sometimes the connection try to open a database first (not sure of that) it confused me.

Jacques

----- Original Message -----
From: Jacques Le Roux
To: pgadmin-support@postgresql.org
Cc: Dave Page ; Andreas Pflug
Sent: Wednesday, November 16, 2005 6:47 PM
Subject: Re: [pgadmin-support] Slow connections from Windows to Linux


From: Dave Page
To: Jacques Le Roux ; pgadmin-support@postgresql.org
Sent: Wednesday, November 16, 2005 2:37 PM
Subject: Re: [pgadmin-support] Slow connections from Windows to Linux






--------------------------------------------------------------------------
From: pgadmin-support-owner@postgresql.org [mailtogadmin-support-owner@postgresql.org] On Behalf Of Jacques Le Roux
Sent: 16 November 2005 12:53
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] Slow connections from Windows to Linux


I was using the previous pgAdmin version (the one packed with Postgres 8.0) on Windows (both 2k and XP). I'm now using the 1.4.0 version. I'm mainly using it to connect from Windows to an Ubuntu Hoary server with PostGres 1.4 on. Previously I encountered very fast connection when opening the database server. Now it's very slow (some minutes) and the postmaster task on server is using a lot of CPU ressources. Any idea ?

Are you using SSL where you weren't previously? Or perhaps logging in pgAdmin (not that that should affect the server's CPU) or PostgreSQL has been set to a very verbose level?

If those are not the issue, then as Andreas says, please try to figure out more about what the server is actually doing.

Regards, Dave

Just trying, using SSL or not is the same : I can't reproduce the problem no more, it's as quick as with previous version. Perhaps something else was involveld. If the problem reappears I will try Andreas suggestion...

Thanks for you Help both )

Jacques

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 09:13 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
www.UnixAdminTalk.com