Обсуждение: Re: SSH connection timing out
I looked at putty's help documentation and found a keep-alive setting that will send empty packets every so often to keepthe session active. It's pretty much the same thing that happens when FTPing to a remote server, and this is of coursethe same recourse used to keep FTPs from timing out as well. Jeremy -----Original Message----- From: Tsirkin Evgeny [mailto:tsurkin@mail.jct.ac.il] Sent: Sunday, February 15, 2004 2:10 AM To: Tom Lane; jer@highboard.com Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] SSH connection timing out Do you use PuTTy as the ssh client? If yes then here you are ,it is the connection problem .i have it all the time and did not found what to do with.Actually that is not only putty problem ,but for example linux ssh client at least does not just freeze - it says something like 'connection timeout'.Just as a proof that this is an ssh problem and not postgres - i have 2 servers with the same config but on diff networks - one neither have a freeze while the other all the time. Evgeny On Sun, 15 Feb 2004 11:56:16 -0500, Tom Lane <tgl@sss.pgh.pa.us> wrote: > "Jeremy Smith" <jer@highboard.com> writes: >> I know this isn't strictly a postgresql question, but I'm sure it >> applies to >> others out there using psql. If I am working in psql from SSH and >> switch to >> another window, it seems that there is a very short window of time >> before >> the window freezes and doesn't allow any more input. > > Never heard of such a problem before. What's your environment, and > would you give a more complete description of the problem? > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
Hi Evgeny, yes I am PUTTY. I knew it wasn't a postgres problem, but thought there might be some server variable controlling timeout. I didn't know that other SSH clients didn't have the same thing happen. Since I am logging to my machine remotely,I can't use the linux ssh client, but I'll see if anything else is out there. Jeremy -----Original Message----- From: Tsirkin Evgeny [mailto:tsurkin@mail.jct.ac.il] Sent: Sunday, February 15, 2004 2:10 AM To: Tom Lane; jer@highboard.com Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] SSH connection timing out Do you use PuTTy as the ssh client? If yes then here you are ,it is the connection problem .i have it all the time and did not found what to do with.Actually that is not only putty problem ,but for example linux ssh client at least does not just freeze - it says something like 'connection timeout'.Just as a proof that this is an ssh problem and not postgres - i have 2 servers with the same config but on diff networks - one neither have a freeze while the other all the time. Evgeny On Sun, 15 Feb 2004 11:56:16 -0500, Tom Lane <tgl@sss.pgh.pa.us> wrote: > "Jeremy Smith" <jer@highboard.com> writes: >> I know this isn't strictly a postgresql question, but I'm sure it >> applies to >> others out there using psql. If I am working in psql from SSH and >> switch to >> another window, it seems that there is a very short window of time >> before >> the window freezes and doesn't allow any more input. > > Never heard of such a problem before. What's your environment, and > would you give a more complete description of the problem? > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
Jeremy Smith wrote: > I looked at putty's help documentation and found a keep-alive > setting that will send empty packets every so often to keep the > session active. It's pretty much the same thing that happens > when FTPing to a remote server, and this is of course the same > recourse used to keep FTPs from timing out as well. I also find Putty SSH bursty when redrawing the screen, so locally I just use putty telnet connections. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073
do you mean the "seconds between keepalive" ? and thanks i will try it. Quoting Jeremy Smith <jer@highboard.com>: > I looked at putty's help documentation and found a keep-alive setting that > will send empty packets every so often to keep the session active. It's > pretty much the same thing that happens when FTPing to a remote server, and > this is of course the same recourse used to keep FTPs from timing out as > well. > > Jeremy > > -----Original Message----- > From: Tsirkin Evgeny [mailto:tsurkin@mail.jct.ac.il] > Sent: Sunday, February 15, 2004 2:10 AM > To: Tom Lane; jer@highboard.com > Cc: pgsql-admin@postgresql.org > Subject: Re: [ADMIN] SSH connection timing out > > > Do you use PuTTy as the ssh client? If yes then here you are ,it > is the connection problem .i have it all the time and did not found > what to do with.Actually that is not only putty problem ,but for > example linux ssh client at least does not just freeze - it says > something like 'connection timeout'.Just as a proof that this > is an ssh problem and not postgres - i have 2 servers with the > same config but on diff networks - one neither have a freeze while > the other all the time. > Evgeny > On Sun, 15 Feb 2004 11:56:16 -0500, Tom Lane <tgl@sss.pgh.pa.us> wrote: > > > "Jeremy Smith" <jer@highboard.com> writes: > >> I know this isn't strictly a postgresql question, but I'm sure it > >> applies to > >> others out there using psql. If I am working in psql from SSH and > >> switch to > >> another window, it seems that there is a very short window of time > >> before > >> the window freezes and doesn't allow any more input. > > > > Never heard of such a problem before. What's your environment, and > > would you give a more complete description of the problem? > > > > regards, tom lane > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org > > > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) > >
I look for theese backports, someone could help?
Am Montag, 1. März 2004 14:49 schrieb Christian Frabel: > I look for theese backports, someone could help? For postgresql, see http://people.debian.org/~elphick/. About phppgadmin, I don't know of one. I happened to look at building one yesterday, but it would seem to entail an update of php4, which was a little too much for my taste at that time.