From: | fred(at)ontosys(dot)com |
---|---|
To: | Andy Pearce <andyj(at)interra(dot)demon(dot)co(dot)uk> |
Cc: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: Speed |
Date: | 2001-12-19 23:01:16 |
Message-ID: | 20011219170116.A7753@ontosys.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
On Wed, Dec 19, 2001 at 10:08:37PM -0000, Andy Pearce wrote:
> I've been using pgAdmin for sometime now and find it to be a very
> useful tool. The only problem i've come across is that it is really
> slow when accessing the server.
I've just started using SSH tunneling to connect pgAdmin II to a
remote server and find that the SSH compression cuts the first delay
(response to clicking on 'Databases' in the left panel) from 18sec to
about 8sec.
I also like the fact that the clear text Postgres passwords are now
hidden in the SSH tunnel. I couldn't get pgAdmin to work with 'crypt'
mode password authentication on the server. With this tunnel in place
I might also completely disallow remote access to the postmaster port
on the server.
--
Fred Yankowski fred(at)OntoSys(dot)com tel: +1.630.879.1312
Principal Consultant www.OntoSys.com fax: +1.630.879.1370
OntoSys, Inc 38W242 Deerpath Rd, Batavia, IL 60510, USA
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2001-12-20 08:09:11 | Re: Speed |
Previous Message | Andy Pearce | 2001-12-19 22:08:37 | Speed |