[pgpool-general: 1602] Re: Failover in raw mode
Tatsuo Ishii
ishii at postgresql.org
Thu Apr 11 22:51:35 JST 2013
You need to set failover_command. Yours is empty, so nothing will
happen.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
> ping. Can anybody help?
>
> 09.04.2013, в 15:24, Бородин Владимир <root at simply.name> написал(а):
>
>> Hi all.
>>
>> I've read much information about failover in raw mode but I haven't found the solution yet.
>>
>> I have 3 PostgreSQL nodes running in streaming replication mode - loadtest01g.domain.com (master), loadtest02g.domain.com andloadtest04g.domain.com (two replicas in hot_standby mode). All of them are listening 0.0.0.0:5432. All of them have the line below in pg_hba.conf (that is a disgusting idea but these hosts are for testing):
>> host all all 0.0.0.0/0 trust
>> I can connect to any of them with psql and issue select queries.
>>
>> On loadtest01g I have installed pgpool-II-3.2 and taken the sample config with some modifications (backend addresses, debug_level and timeouts). Config - http://simply.name/tmp/pgpool.conf and log - http://simply.name/tmp/pgpool.log.
>>
>> I get the following problem:
>> pgpool does not failover to backend1 (loadtest02g) if backend0 (loadtest01g) fails down. According to log it catches the primary failure but doesn't send queries to one of the replicas.
>>
>> The question is what do I do wrong?
>>
>> --
>> Vladimir
>> _______________________________________________
>> pgpool-general mailing list
>> pgpool-general at pgpool.net
>> http://www.pgpool.net/mailman/listinfo/pgpool-general
>
>
> --
> Vladimir
>
>
>
>
More information about the pgpool-general
mailing list