Re: AWS and postgres issues

From: David Kerr <dmk(at)mr-paradox(dot)net>
To: Tatsuo Ishii <ishii(at)postgresql(dot)org>
Cc: barwick(at)gmail(dot)com, pgsql-general(at)postgresql(dot)org
Subject: Re: AWS and postgres issues
Date: 2013-04-09 02:20:27
Message-ID: D788D6A2-DB44-4D95-A5AA-BAFCF27A8E86@mr-paradox.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Apr 8, 2013, at 5:52 PM, Tatsuo Ishii <ishii(at)postgresql(dot)org> wrote:

>> 2013/4/9 Tatsuo Ishii <ishii(at)postgresql(dot)org>:
>>>> While debugging this with a coworker we figured out that pg_ctl was attaching to the tty and then it clicked
>>>> that we needed to be using '-t' where I was using -T or (neither).
>>>
>>> Are you sure? I checked the pg_ctl source code and could not find any
>>> place attaching to the tty.
>>
>> I think he means the ssh options -t and -T
>
> Yes, I know. In my understanding, he is saying because pg_ctl attaches
> to the tty, and ssh should be executed with -t (force ssh to allocate
> pseudo-tty).
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese: http://www.sraoss.co.jp
>

Yeah, and i really expected to NOT want to attach to the pseudo-tty.

I was also sort of hoping that it was dropping packets or something like that because
then it might have been a similar problem to the one i reported here:
http://www.pgpool.net/pipermail/pgpool-general/2013-February/001418.html

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ascot Moss 2013-04-09 02:45:59 PostgreSQL 9.1.8 Upgrade to 9.1.9
Previous Message Kevin Grittner 2013-04-09 02:09:35 Re: Inconsistent query performance