Re: [pgadmin-support] Pgadmin III loses connection with remote database and then hangs for a long time.

2011-05-31 Thread Tim Uckun
> > I have seen similar problems on routers and switches that were > overloaded or misconfigured. Adding memory, or just increasing the > number of buffers available might fix the problem. My router is simply an ADSL modem, I have no control over the multitude of routers that are in the way betwee

Re: [pgadmin-support] Pgadmin III loses connection with remote database and then hangs for a long time.

2011-05-31 Thread Tim Uckun
> > You can play with the tcp parameters in postgresql.conf to make sure > your tcp line is alive. That's an idea. Thanks. -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support

Re: [pgadmin-support] Pgadmin III loses connection with remote database and then hangs for a long time.

2011-05-31 Thread Guillaume Lelarge
On Sun, 2011-05-29 at 13:09 +1200, Tim Uckun wrote: > > > > And no switch between them? Usually, this kind of issues happens because > > of a faulty firewall or switch. > > I am sure there are lots of switches between me and the database. I > live in New Zealand and the server is usually in the US

Re: [pgadmin-support] pgadmin installation on Windows XP without administrator rights

2011-05-31 Thread Dave Page
On Tue, May 31, 2011 at 5:11 PM, Robert Bruccoleri < b...@stone.congenomics.com> wrote: > Dear Dave, > Your suggestion worked although with some errors. Most importantly, I > was able to run pgadmin3 and access the PostgreSQL server successfully. Here > are the warnings: > > Oh good - thanks

Re: [pgadmin-support] pgadmin installation on Windows XP without administrator rights

2011-05-31 Thread Dave Page
On Tue, May 31, 2011 at 3:53 PM, Robert Bruccoleri < b...@stone.congenomics.com> wrote: > Dear Dave, > I'm not getting a password prompt -- just errors. I ran a number of > installation attempts and captured the results: > > I tried several different versions of pgAdmin. With the

Re: [pgadmin-support] Pgadmin III loses connection with remote database and then hangs for a long time.

2011-05-31 Thread Bob McConnell
From: Guillaume Lelarge > On 05/26/2011 09:45 AM, Tim Uckun wrote: >> I am using pgAdmin 1.12.1 oct 21 2010 rev-REL-1_12_1 from Martin >> Pitt's PPA on ubuntu maverick. >> >> Often when I connect to remote database the program seems to lose >> connection to the database and when this happens it j

Re: [pgadmin-support] COMMENT on a wrong object

2011-05-31 Thread Guillaume Lelarge
Hi, On Tue, 2011-05-31 at 15:25 +0900, Shigeru Hanada wrote: > [...] > I found that pgAdmin wrongly defines a comment of a foreign table on its > relevant type object. The comment should be defined on the foreign table > itself. > > This occurs on both of creation and modification. The cause wou

Re: [pgadmin-support] pgadmin installation on Windows XP without administrator rights

2011-05-31 Thread Dave Page
Hi On Tue, May 31, 2011 at 3:18 AM, Robert Bruccoleri wrote: > I am working at a location where I would like to test connectivity to a > Linux PostgreSQL database from Windows XP, and it was suggested to me that I > try using pgAdmin for that purpose. Unfortunately, I've run into a problem > -- p