Re: [Bug / Question ] " authentication_timeout " is invalid.

Thank you for all your assistance.

Best Regard,
James

2015-09-18 1:03 GMT+08:00 Jeff Janes <jeff(dot)janes(at)gmail(dot)com>:

> On Wed, Sep 16, 2015 at 9:02 PM, 林俊彥 <james(dot)lin(at)cenoq(dot)com> wrote:
>
>> Hi , Jeff,
>> Thank you for reply. I used to use in the following ways but still
>> could not be verified:
>> ----------- Log start ---------------------
>> [BEGIN] 2015/9/17 11:51:51
>> [postgres(at)pg95 ~]$ cat test.sh
>>
>> #!/bin/bash
>> ip a |grep eth0
>> psql -h 100.200.100.211<<EOF
>> show authentication_timeout;
>> select now();
>> \! sh net_test.sh
>> select now();
>> EOF
>>
>
>
> That isn't going to work because net_test.sh isn't called until after the
> connection is authenticated.
>
> It is difficult to interrupt the process during the brief instant between
> when the connection was opened and when it is authenticated.
>
> Start psql, and when it is waiting for the password, find the pid for psql
> and start gdb against the psql process (gdb -p <pid>)
>
> In gdb, do:
>
> (gdb) b PQconnectStartParams
> Breakpoint 1 at 0x7f5de60bdf70: file fe-connect.c, line 561.
> (gdb) c
>
> Then go back and complete the password in psql. The gdb session will have
> triggered the breakpoint.
>
> Wait for less than the timeout, and hit 'c' and enter in the debugger.
> The connection will complete.
>
> Or, wait for more than the timeout and hit 'c' and enter in the debugger.
> The connection will error out, as the server side hung up on it.
>
> Cheers,
>
> Jeff
>