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

2009-11-12 Thread Eugene Lisitsky
2009/11/12 Dave Page > On Thu, Nov 12, 2009 at 11:55 AM, Eugene Lisitsky > wrote: > > > > $ wx-config --cflags > > -I/usr/lib/wx/include/base-unicode-release-2.8 -I/usr/include/wx-2.8 > > -D_FILE_OFFSET_BITS=64 -D_LARGE_FILES -DwxUSE_GUI=0 -pthread > > Not sure what to suggest then. I just insta

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

2009-11-12 Thread Dave Page
On Thu, Nov 12, 2009 at 1:15 PM, Michael Shapiro wrote: > Yes, I am using Windows. I wouldn't describe what I see as hanging or > freezing, just losing the connection and then crashing if I try to run the > query again Let's try to keep these issues seperate then - they clearly have different

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

2009-11-12 Thread Pedro Doria Meunier
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Michael, My postgresql.conf, tcp-related, bit: tcp_keepalives_idle = 75# TCP_KEEPIDLE, in seconds; # 0 selects the system default tcp_keepalives_interval = 60# TCP_KEEPINTVL, in secon

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

2009-11-12 Thread Dave Page
On Thu, Nov 12, 2009 at 11:55 AM, Eugene Lisitsky wrote: > > $ wx-config --cflags > -I/usr/lib/wx/include/base-unicode-release-2.8 -I/usr/include/wx-2.8 > -D_FILE_OFFSET_BITS=64 -D_LARGE_FILES -DwxUSE_GUI=0 -pthread Not sure what to suggest then. I just installed on a Karmic box I'm testing here,

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

2009-11-12 Thread Michael Shapiro
Yes, I am using Windows. I wouldn't describe what I see as hanging or freezing, just losing the connection and then crashing if I try to run the query again On Thu, Nov 12, 2009 at 7:11 AM, Dave Page wrote: > On Thu, Nov 12, 2009 at 1:08 PM, Michael Shapiro > wrote: > > > Note that if someo

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

2009-11-12 Thread Dave Page
On Thu, Nov 12, 2009 at 1:08 PM, Michael Shapiro wrote: > Note that if someone wants to replicate my problem, they could use these > settings and run PgAdmin from a Windows box (since the settings don't mean > anything for Unix connections). It hangs on a Windows box? -- Dave Page EnterpriseD

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

2009-11-12 Thread Michael Shapiro
My server's setting are: 'tcp_keepalives_count','9' 'tcp_keepalives_idle','7200' 'tcp_keepalives_interval','75' and I still get the problem. I just have to wait 20 minutes or so. (I don't really know how to predict how long it takes to lose a connection, even knowing these settings) Note that i

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

2009-11-12 Thread Eugene Lisitsky
2009/11/12 Dave Page > On Thu, Nov 12, 2009 at 10:32 AM, Eugene Lisitsky > wrote: > >> I can't get excited at the thought of cluttering the UI to resolve a > >> minor issue. I'd rather we tried to read the pgpass file so we could > >> default the password. Not sure how much effort that would tak

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

2009-11-12 Thread Pedro Doria Meunier
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Dave, I was thinking about Michael's observations and the fact that this problem never happened if the server status window was opened. So what I did was: set the "tcp_keepalives_interval" = 75 and reloaded the server's configuration. No more fre

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

2009-11-12 Thread Dave Page
On Thu, Nov 12, 2009 at 11:06 AM, Pedro Doria Meunier wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > I'm sorry Dave. > > I'm unable to... :( > > Whenever I try to get a backtrace it's already frozen solid and > there's nothing to do other than kill it... If you start it under gdb, d

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

2009-11-12 Thread Pedro Doria Meunier
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I'm sorry Dave. I'm unable to... :( Whenever I try to get a backtrace it's already frozen solid and there's nothing to do other than kill it... BR, Pedro On 11/12/2009 10:43 AM, Dave Page wrote: > On Thu, Nov 12, 2009 at 10:41 AM, Pedro Doria Meuni

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

2009-11-12 Thread Dave Page
On Thu, Nov 12, 2009 at 10:41 AM, Pedro Doria Meunier wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Dave, > > With SSL disable it's the same thing... Can you get the trace please? -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- Sent via pgadmin-support mailing lis

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

2009-11-12 Thread Pedro Doria Meunier
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Dave, With SSL disable it's the same thing... BR, Pedro. On 11/12/2009 09:22 AM, Dave Page wrote: > On Wed, Nov 11, 2009 at 8:00 PM, Pedro Doria Meunier > wrote: >> -BEGIN PGP SIGNED MESSAGE- >> Hash: SHA1 >> >> Ok. please disregard that l

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

2009-11-12 Thread Dave Page
On Thu, Nov 12, 2009 at 10:32 AM, Eugene Lisitsky wrote: >> I can't get excited at the thought of cluttering the UI to resolve a >> minor issue. I'd rather we tried to read the pgpass file so we could >> default the password. Not sure how much effort that would take, but we >> can probably lift mu

Re: [pgadmin-support] Help!

2009-11-12 Thread Dave Page
On Thu, Nov 12, 2009 at 10:12 AM, John Weller wrote: > I am a complete newbie to PostgreSQL.  I have been using Visual FoxPro for > many years and now need to use a product which can support much larger data > tables so decided to use PostgreSQL.  I am following Rich Blum's book on > PostgreSQL 8

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

2009-11-12 Thread Eugene Lisitsky
> > I can't get excited at the thought of cluttering the UI to resolve a > minor issue. I'd rather we tried to read the pgpass file so we could > default the password. Not sure how much effort that would take, but we > can probably lift much of the code from libpq. > Excellent idea! How do you writ

[pgadmin-support] Help!

2009-11-12 Thread John Weller
I am a complete newbie to PostgreSQL. I have been using Visual FoxPro for many years and now need to use a product which can support much larger data tables so decided to use PostgreSQL. I am following Rich Blum's book on PostgreSQL 8 for Windows and have hit a problem. I have created a schema,

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

2009-11-12 Thread Dave Page
On Wed, Nov 11, 2009 at 8:00 PM, Pedro Doria Meunier wrote: > -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 uninit

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

2009-11-12 Thread Dave Page
On Wed, Nov 11, 2009 at 6:57 PM, Pedro Doria Meunier wrote: > -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 director

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

2009-11-12 Thread Dave Page
2009/11/11 Eugene Lisitsky : > > What do you think of adding one more button to the dialog "Use stored pass" > which just does nothing only sends the connection request? I can't get excited at the thought of cluttering the UI to resolve a minor issue. I'd rather we tried to read the pgpass file so