As far as I can see there is nothing wrong here either. Bear in mind that with full Debug turned on, things will be *significantly* slower because not only is pgAdmin producing a full log, psqlodbc is logging things flat out as well. 1 minute is not an unreasonable time to view aggregates (which also loads all functions) in this mode.
What bandwidth to the server do you have? What spec are the client and server machines, and how loaded are they? How long does it take with logging turned off if you just let it finish? Regards, Dave. > -----Original Message----- > From: Çagil Seker [mailto:[EMAIL PROTECTED]] > Sent: 25 November 2002 10:49 > To: Dave Page > Cc: PGAdmin-Support-List (E-mail) > Subject: RE: [pgadmin-support] Connection & Crash Problem > From Domain Users > > > I opened the pgAdmin2. Change the log file to > ...CRASH...something. Then connected to postmaster. > Double-clicked the EDYS db. dc'ed the schema. dc'ed the > public object. And it stopped responding. Waited a minute. > Then closed it by CTRL-ALT-DEL. I don't know if this log file > is any different form the prev. one. Here it is.. > > Çagil SEKER > ----------------- > > -----Original Message----- > > From: Çağıl Şeker > > Sent: 23 Kasim 2002 Cumartesi 13:12 > > To: 'Dave Page' > > Cc: PGAdmin-Support-List (E-mail) > > Subject: RE: [pgadmin-support] Connection & Crash Problem > > From Domain Users > > > > > > > -----Original Message----- > > > From: Dave Page [mailto:[EMAIL PROTECTED]] > > > Sent: 21 Kasim 2002 Persembe 22:57 > > > To: Çağıl Şeker; PGAdmin-Support-List (E-mail) > > > Subject: RE: [pgadmin-support] Connection & Crash Problem > > > From Domain Users > > > > > > > > > > > > > > > > -----Original Message----- > > > > From: Çagil Seker [mailto:[EMAIL PROTECTED]] > > > > Sent: 21 November 2002 17:27 > > > > To: PGAdmin-Support-List (E-mail) > > > > Subject: [pgadmin-support] Connection & Crash Problem From > > > > Domain Users > > > > > > > > > > > > Ok. now I have a new problem! > > > > I can use pgadmin without any problem under the local W2K > > > > accounts POSTGRES and TESTUSER. But if I run pgadmin under > > > > the domain W2K account MYDOMAIN/CAGILS it connects (and is > > > > very slowly) and then when I try to reach the public database > > > > object which is created default, it crashes (stops > > > > responding, the log runs in a loop like crazy). I can reach > > > > to postmaster using psql under MYDOMAIN/CAGILS > > > > > > Hmm, interesting. It's certainly not directly related to the > > > fact it's a domain uid - it was 100% developed using one! Can > > > you produce a full debug log (under Tools->Options) from > > > connect to crash for me please? > > > > > > Also, what caused the change in UID 2/3 of the way through > > > your original email? Initially you were postgres, then > > > administrator - did you change login, or is there something > > > going cuckoo with your Cygwin environment? > > > > > > Regards, Dave. > > > > > > > I am sending the full debug log of a session. From connection > > setup to the crash when I click to the public object. The log > > is within the attachment. > > > > I log on to cygwin with Administrator. Then I "ssh > > postgres@localhost". The first part was with ssh. The second > > Admin. part is after I typed an "exit". Sorry, I'd snip it. > > > > And thanks for your help. > > > > Çagil SEKER > > ----------------- > > "Yes, I am a criminal. My crime is that of outsmarting you. > > Something that you'll never forgive me for!" - The Mentor'86 > > (Hacker's Manifesto) > > ----------------- > > > ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
