Обсуждение: Problem to use remote cygwin server using ssh and native psql 8.3.5

I have installed cycwin and sshd in my Windows server.

I have Winnative psql.exe (8.3.5)

If I use cygwin locally in this server and give command in cygwin session:
    psql -h somehost -U someuser -d somedb
it works fine

But if i use via ssh same way, then no echo ... and process hang.

I have tested remote ssh and local

Cygwin session
    ssh localhost
    => connect local, ...
    psql -h somehost -U someuser -d somedb
    will hang

Cygwin old native psql 8.2 works, but I like to use newer psql = Win
native psql.exe

tested using Cygwin 1.5.x and 1.7.x

Ssh tty problem using Windows native psql.exe  ?

-jukka-

On Sun, Nov 8, 2009 at 12:35, Jukka Inkeri <pg@awot.fi> wrote:
>
> I have installed cycwin and sshd in my Windows server.
>
> I have Winnative psql.exe (8.3.5)
>
> If I use cygwin locally in this server and give command in cygwin session:
>   psql -h somehost -U someuser -d somedb
> it works fine
>
> But if i use via ssh same way, then no echo ... and process hang.
>
> I have tested remote ssh and local
>
> Cygwin session
>   ssh localhost
>   => connect local, ...
>   psql -h somehost -U someuser -d somedb
>   will hang
>
> Cygwin old native psql 8.2 works, but I like to use newer psql = Win native
> psql.exe
>
> tested using Cygwin 1.5.x and 1.7.x
>
> Ssh tty problem using Windows native psql.exe  ?

The native psql is written for Windows, not for Cygwin. You really
shouldn't be using it there... If you are using Cygwin, you should be
using a Cygwin psql.exe.


--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/

>
> The native psql is written for Windows, not for Cygwin. You really
> shouldn't be using it there... If you are using Cygwin, you should be
> using a Cygwin psql.exe.
>
>

PG pages says: use native, not cygwin version anymore. It's not problem
if it's "windows" binary, you can use many native binary commands in
cygwin, ex. java. psql termio is the problem. If I translate 8.4.1 using
gcc, those binary not work also.

Psql not work. It works, if you set -f - = stdin, but then you not get
command prompt and that kind of psql output.

My scripts works now, after I use win binary psql with flag -f, just as
I said in my own answer.

-jukka-

On Mon, Nov 9, 2009 at 06:15, Jukka Inkeri <pg@awot.fi> wrote:
>
>>
>> The native psql is written for Windows, not for Cygwin. You really
>> shouldn't be using it there... If you are using Cygwin, you should be
>> using a Cygwin psql.exe.
>>
>>
>
> PG pages says: use native, not cygwin version anymore.

Yes, that is for the Windows platform. Cygwin is a different platform,
really. Perhaps we should clarify that - what page exactly are you
referring to?

> It's not problem if
> it's "windows" binary, you can use many native binary commands in cygwin,
> ex. java. psql termio is the problem. If I translate 8.4.1 using gcc, those
> binary not work also.

Right. The problem is that the cygwin terminal is not fully windows
compatible. This is why when using Cygwin, you should be using Cygwin
binaries.


> My scripts works now, after I use win binary psql with flag -f, just as I
> said in my own answer.

Glad to see you got it working.


--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/