Re: Patch: Implement failover on libpq connect level.

Поиск
Список
Период
Сортировка
От Thom Brown
Тема Re: Patch: Implement failover on libpq connect level.
Дата
Msg-id CAA-aLv7KGGgoSU+fa8NNisL11DKrs-BGh8qwNQjFZ1NuDC+Yxw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Patch: Implement failover on libpq connect level.  (Victor Wagner <vitus@wagner.pp.ru>)
Ответы Re: Patch: Implement failover on libpq connect level.  (Thom Brown <thom@linux.com>)
Re: Patch: Implement failover on libpq connect level.  (Thom Brown <thom@linux.com>)
Список pgsql-hackers
On 22 January 2016 at 19:30, Victor Wagner <vitus@wagner.pp.ru> wrote:
> On Tue, 19 Jan 2016 14:34:54 +0000
> Thom Brown <thom@linux.com> wrote:
>
>>
>> The segfault issue I originally reported now appears to be resolved.
>>
>> But now I have another one:
>>
>> psql
>>
'postgresql://thom@127.0.0.1:5530,127.0.0.1:5531,127.0.0.1:5532,127.0.0.1:5533/postgres?hostorder=random&readonly=1&failover_timeout=5'
>> -c 'show port'
>
> Here is new version of the patch. Now I've reworked hostorder=random and
> it seems to work as well as sequential. failover_timeout works too.
> I've also found a case when attempt to connect fail when receiving
> FATAL message from server which is not properly up yet. So, it is fixed
> too.
>
> Addititonally, error messages from all failed connect attempts are not
> accumulated now. Only last one is returned.

I can't connect to a standby with the patch applied:

thom@swift:~/Development/test$ psql -p 5531 postgres
psql: thom@swift:~/Development/test$

No error message, nothing in the logs.  I find this is the case with
any standby, but doesn't affect primaries.

So this has broken existing functionality somewhere.

Thom



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Steve Singer
Дата:
Сообщение: Re: pglogical - logical replication contrib module
Следующее
От: Thom Brown
Дата:
Сообщение: Re: Patch: Implement failover on libpq connect level.