Re: Speed

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@OntoSys.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