Re: [pgadmin-support] pgAdmin ver 1.10 freezing all too frequently

2009-11-11 Thread Michael Shapiro
I did a bit more checking and there appears to be some server configurations that may affect keeping the connection alive: tcp_keepalives_idle (integer) On systems that support the TCP_KEEPIDLE socket option, specifies the number of seconds between sending keepalives on an otherwise idle connecti

Re: [pgadmin-support] pgAdmin ver 1.10 freezing all too frequently

2009-11-11 Thread Michael Shapiro
I checked the server logs and found messages like this: 2009-11-11 15:08:36 PSTLOG: could not receive data from client: Connection reset by peer 2009-11-11 16:18:11 PSTLOG: could not receive data from client: Connection timed out I do not know if this means that the server did the disconnect or

Re: [pgadmin-support] pgAdmin ver 1.10 freezing all too frequently

2009-11-11 Thread Michael Shapiro
I was able to reproduce the problem within PgAdmin as well as with another (java-based) tool connecting to the same database from the same (Windows XP) machine. I opened an query window and ran a query (that did not take long to complete) in both tools. I then waited 1/2 hour and ran the query aga

[pgadmin-support] PostgreSQL 8.5

2009-11-11 Thread Vladimir Kokovic'
Hi, I can confirm that version of pgAdmin (svn rev 8077) works with PostgreSQL 8.5. The PostgreSQL log is without any warning or error in the operations that I use. Warning: This version of pgAdmin has only been tested with PostgreSQL version 8.4 and below and may not function correctly with

Re: [pgadmin-support] pgAdmin ver 1.10 freezing all too frequently - follow up

2009-11-11 Thread Pedro Doria Meunier
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Ok... I've tried with valgrind and gdb attached ... no luck with gdb alone and trying to get a stack trace ... no luck whatever is happening with pgadmin3 under the beforementioned conditions *freezes* everything ... BR, Pedro On 11/11/2009 08:00

Re: [pgadmin-support] pgAdmin ver 1.10 freezing all too frequently

2009-11-11 Thread Pedro Doria Meunier
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Ok. please disregard that last one... :) This is the last output of valgrind before I had to kill pgadmin: ==671== Thread 2: ==671== Syscall param write(buf) points to uninitialised byte(s) ==671==at 0xBC4F4B: (within /lib/libpthread-2.10.1.so) =

Re: [pgadmin-support] pgAdmin ver 1.10 freezing all too frequently

2009-11-11 Thread Pedro Doria Meunier
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Dave Did as you asked... problem: ./pgadmin3: error while loading shared libraries: libwx_gtk2ud_stc-2.8.so.0: cannot open shared object file: No such file or directory (on execution, after compilation) This library is nowhere to be found... Do

[pgadmin-support] Text Search Configuration Mapping displayed out of order, pgAdmin 1.10.0

2009-11-11 Thread Jean-Pierre Pelletier
Hi, We've noticed that pgAdmin displays the mapping of text search configurations out of order after using pg_dump & pg_restore with pgAdmin 1.10.0 against PostgreSQL 8.3.8 on Windows Server 2008 64 bits. Thanks, Jean-Pierre Pelletier Steps to reproduce: CREATE SCHEMA my_text_search_configu

Re: [pgadmin-support] PostgreSQL 8.5

2009-11-11 Thread Guillaume Lelarge
Le mercredi 11 novembre 2009 à 19:01:31, Vladimir Kokovic' a écrit : > Hi, > > Has anyone tried pgAdmin with PostgreSQL 8.5 ? > > pgAdmin(svn version) reports: > > Warning: > This version of pgAdmin has only been tested with PostgreSQL version 8.4 > and below and may not function correctly with

Re: [pgadmin-support] PostgreSQL 8.5

2009-11-11 Thread Raymond O'Donnell
On 11/11/2009 17:51, Vladimir Kokovic' wrote: > Hi, > > Has anyone tried pgadmin3 with PostgreSQL 8.5 ? > > pgadmin3 reports: > > Warning: > This version of pgAdmin has only been tested with PostgreSQL version 8.4 > and below and may not function correctly with this server. Please > upgrade pgAd

[pgadmin-support] PostgreSQL 8.5

2009-11-11 Thread Vladimir Kokovic'
Hi, Has anyone tried pgAdmin with PostgreSQL 8.5 ? pgAdmin(svn version) reports: Warning: This version of pgAdmin has only been tested with PostgreSQL version 8.4 and below and may not function correctly with this server. Please upgrade pgAdmin. Best regards, Vladimir Kokovic, DP senior, Be

[pgadmin-support] PostgreSQL 8.5

2009-11-11 Thread Vladimir Kokovic'
Hi, Has anyone tried pgadmin3 with PostgreSQL 8.5 ? pgadmin3 reports: Warning: This version of pgAdmin has only been tested with PostgreSQL version 8.4 and below and may not function correctly with this server. Please upgrade pgAdmin. Best regards, Vladimir Kokovic', DP senior, Belgrade, Se

Re: [pgadmin-support] PgAdmin forgets stored password on connection problem

2009-11-11 Thread Eugene Lisitsky
2009/11/11 Dave Page > On Wed, Nov 11, 2009 at 3:33 PM, Eugene Lisitsky > wrote: > > > Is it possible to check error and fail reason: network, connection > refused, > > password incorrect, no access to such DB? > > Not reliably, because we only get CONNECTION_GOOD, CONNECTION_BAD as > connection

Re: [pgadmin-support] PgAdmin forgets stored password on connection problem

2009-11-11 Thread Dave Page
On Wed, Nov 11, 2009 at 3:33 PM, Eugene Lisitsky wrote: > Is it possible to check error and fail reason: network, connection refused, > password incorrect, no access to such DB? Not reliably, because we only get CONNECTION_GOOD, CONNECTION_BAD as connection status flags from libpq, and in the ev

Re: [pgadmin-support] pgAdmin ver 1.10 freezing all too frequently

2009-11-11 Thread Dave Page
On Wed, Nov 11, 2009 at 3:36 PM, Pedro Doria Meunier wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > I'm "glad" :] I'm not alone in this... > > It's definitely not the router. It's something else... > > For instance: > > - - One opens a table. leave it be for some time and the next op

Re: [pgadmin-support] pgAdmin ver 1.10 freezing all too frequently

2009-11-11 Thread Pedro Doria Meunier
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I'm "glad" :] I'm not alone in this... It's definitely not the router. It's something else... For instance: - - One opens a table. leave it be for some time and the next operation freezes pgAdmin, especially if one tries to open another database obj

Re: [pgadmin-support] PgAdmin forgets stored password on connection problem

2009-11-11 Thread Eugene Lisitsky
Thank you, Dave! 2009/11/11 Dave Page > On Wed, Nov 11, 2009 at 2:17 PM, Eugene Lisitsky > wrote: > > Hi! > > Thank you for the great program and constant improvement! > > I meet only several troubles usign it, one of them is: > > If you have stored password in connections and a connection atte

Re: [pgadmin-support] pgAdmin ver 1.10 freezing all too frequently

2009-11-11 Thread Michael Shapiro
It just happened again. I ran a query in a window and after it completed I waited 10-15 minutes and ran it again. I got a connection error. I ran the query again (by hitting the green > icon) and it caused pgAdmin to crash. Moreover, I was simultaneously running another tool that was connected to

Re: [pgadmin-support] Query window and non-english text

2009-11-11 Thread Dave Page
On Wed, Nov 11, 2009 at 2:31 PM, Eugene Lisitsky wrote: > Hi! > Thank you for the program! > I found one strange bug in Query window. > If you type Russian letters in it and then use cursor movement key - arrows > or backspace or delete, after you cannot type in Russian any more. You can > press l

Re: [pgadmin-support] PgAdmin forgets stored password on connection problem

2009-11-11 Thread Dave Page
On Wed, Nov 11, 2009 at 2:17 PM, Eugene Lisitsky wrote: > Hi! > Thank you for the great program and constant improvement! > I meet only several troubles usign it, one of them is: > If you have stored password in connections and a connection attempt was > failed (due to some network problems for ex

Re: [pgadmin-support] Deleting servers

2009-11-11 Thread Dave Page
On Wed, Nov 11, 2009 at 2:06 PM, Maximilian Tyrtania wrote: > ...from the main window of PGAdmin III 1.10.0 doesn't appear to work. > Selected the server-entry, chose "drop" from the contextmenu, confirmed the > dialog. The entry disappeared. Quit PGAdmin, relaunched it, and the entry was > the

Re: [pgadmin-support] pgAdmin ver 1.10 freezing all too frequently

2009-11-11 Thread Michael Shapiro
It happens to me quite a lot, as well. I will lose the contents of the SQL window as well when it happens. It would be good if PgAdmin would automatically try to reconnect (at least once) before giving up. On Wed, Nov 11, 2009 at 8:08 AM, Eugene Lisitsky wrote: > > I see such problem when remot

[pgadmin-support] Query window and non-english text

2009-11-11 Thread Eugene Lisitsky
Hi! Thank you for the program! I found one strange bug in Query window. If you type Russian letters in it and then use cursor movement key - arrows or backspace or delete, after you cannot type in Russian any more. You can press letters on keyboard but nothing happens in the window. If you press

[pgadmin-support] PgAdmin forgets stored password on connection problem

2009-11-11 Thread Eugene Lisitsky
Hi! Thank you for the great program and constant improvement! I meet only several troubles usign it, one of them is: If you have stored password in connections and a connection attempt was failed (due to some network problems for example) then PgAdmin asks you to prompt the password again on next

[pgadmin-support] Deleting servers

2009-11-11 Thread Maximilian Tyrtania
...from the main window of PGAdmin III 1.10.0 doesn't appear to work. Selected the server-entry, chose "drop" from the contextmenu, confirmed the dialog. The entry disappeared. Quit PGAdmin, relaunched it, and the entry was there again. I'm on Mac OS 10.6.2 Best wishes from Berlin, Maximilian

Re: [pgadmin-support] pgAdmin ver 1.10 freezing all too frequently

2009-11-11 Thread Eugene Lisitsky
I see such problem when remote servers replies slowly. 2009/11/1 Pedro Doria Meunier > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Replying to self: > Altering the tcp_keepalive_time, tcp_keepalive_intvl values *didn't* > solve the problem. > > > On 11/01/2009 03:04 PM, Pedro Doria Meun

Re: [pgadmin-support] Missing pgagent on 1.10.0 FreeBSD port?

2009-11-11 Thread Dave Page
On Tue, Nov 10, 2009 at 10:40 PM, Benjamin Krajmalnik wrote: > It appears that pgagent is missing from the FreeBSD port of pgAdmin3 1.10.0. > > Can someone confirm this? > > I just built a new test environment and unfortunately pgagent does not > appear to be installed when installing pgAdmin. pg