Re: [pgadmin-support] How to use SSH tunnels with pgAdmin?

2010-02-28 Thread Josh Berkus
> The connections aren't being dropped when I work with my other PG tool, PG > Lightning Admin, which does use SSH tunnels. In that case: http://oldsite.precedence.co.uk/nc/putty.html --Josh Berkus -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to

Re: [pgadmin-support] How to use SSH tunnels with pgAdmin?

2010-02-28 Thread Dave Page
On Sun, Feb 28, 2010 at 6:12 PM, Ken Winter wrote: > Thanks, Dave. > > Following this lead, I tried to set up a SSH tunnel session using: > > a. PuTTY, > > b. my host's (WebFaction.com) instructions at > http://docs.webfaction.com/user-guide/databases.html#accessing-a-database-re > motely, and > >

Re: [pgadmin-support] Output to file

2010-02-28 Thread Guillaume Lelarge
Le 27/02/2010 23:04, John Gage a écrit : > Is there a way to have sequential SELECT queries output to the same file > without having the second SELECT overwrite the first. > > Here is a sample: > > SELECT * FROM prof_texts_lines WHERE source_lines ~* '(enregistrement)' > ORDER BY line_no ; > > S

Re: [pgadmin-support] How to use SSH tunnels with pgAdmin?

2010-02-28 Thread Guillaume Lelarge
Le 27/02/2010 21:18, Ken Winter a écrit : > I'm suffering from a lot of dropped connections between pgAdmin and my PG > databases, even after very brief inactivity. > > > > Your documentation at http://www.pgadmin.org/support/faq.php#ConnDrop says: > > > > .you could use a SSH tunnel for Po

Re: [pgadmin-support] How to have 2 connections, same server, different user?

2010-02-28 Thread Guillaume Lelarge
Le 26/02/2010 20:58, Josh Berkus a écrit : > While the main pgadmin console lets me define multiple connections to > the same server in different roles, the SQL query window will not let me > select them. Once I've selected a connection as a specific role (say, > postgres:5488), then I cannot ever

Re: [pgadmin-support] Window Size SQL-query

2010-02-28 Thread Guillaume Lelarge
Le 24/02/2010 15:40, Andreas Laggner a écrit : > Hi List, > > i'm running 1.10.0 binary with openSuse 11.2 64bit. When i open a > sql-query the window size is standard and not as i left it last time i > used pgadmin3. How can i get pgadmin3 remembering the window size? Hint: > this problem occurs

Re: [pgadmin-support] pgAdmin 1.10.1 default parameters error

2010-02-28 Thread Guillaume Lelarge
Le 24/02/2010 12:19, Volobuyev Andrey a écrit : > If I create function with 2 or more default parameters in pgAdmin 1.10.1 for > windows, then after the command "Create Script" in function's tree I see > incorrect definition of function - default value is displayed only for every > second parameter

Re: [pgadmin-support] Graphical Query Builder - usage stats?

2010-02-28 Thread Guillaume Lelarge
Le 21/02/2010 17:10, Fernando Hevia a écrit : > Well... I don't use it either. The only place I have used anything like a > graphical query builder (or wizard) was in MS Access, but thats just because > of the crazy sql syntax that thing has. > I don't use it either. But it doesn't mean we don't

Re: [pgadmin-support] How to use SSH tunnels with pgAdmin?

2010-02-28 Thread Dave Page
On Sun, Feb 28, 2010 at 2:39 AM, Ken Winter wrote: > The connections aren't being dropped when I work with my other PG tool, PG > Lightning Admin, which does use SSH tunnels. The first hit I see on Google for 'pgadmin ssh tunnel' is this: http://www.postgresonline.com/journal/index.php?/archives