[pgpool-general: 6131] Re: PgPool in streaming replication mode without failover and primary down

[Andre Piwoni]

Wolf,
Do you mind sharing relevant configuration and version of pgpool you are
using? Do you have more than one slave?

I have tried the following combinations:

backend_flag0 = 'ALWAYS_MASTER|DISALLOW_TO_FAILOVER'
backend_flag1 = 'DISALLOW_TO_FAILOVER'

backend_flag0 = 'ALWAYS_MASTER'
backend_flag1 = 'DISALLOW_TO_FAILOVER'

backend_flag0 = 'ALWAYS_MASTER'
backend_flag1 = 'ALLOW_TO_FAILOVER'

master_slave_mode = on
master_slave_sub_mode = 'stream'

sr_check_period = 0 and default sr_check_period = 10
health_check_period = 0
failover_command = ''
fail_over_on_backend_error = off and fail_over_on_backend_error = on

On Wed, Jun 20, 2018 at 8:40 AM, Wolf Schwurack <wolf at uen.org> wrote:

> Yes it is possible I have all my Pgpool hosts setup that way. My setup is
> a streaming replica and I don't apply the failover.sh script. If the master
> goes down pgpool fails over to the standby in readonly mode.
>
>
> Wolfgang Schwurack
> Database/System Administrator
> Utah Education Network
> 801-587-9444
> wolf at uen.org
>
>
>
> On 6/19/18, 9:48 PM, "pgpool-general-bounces at pgpool.net on behalf of Bo
> Peng" <pgpool-general-bounces at pgpool.net on behalf of pengbo at sraoss.co.jp>
> wrote:
>
>     Which version of Pgpool-II do you use?
>     It also happened by latest version of Pgpool-II 3.7.4?
>
>     On Tue, 19 Jun 2018 20:00:58 -0700
>     Andre Piwoni <apiwoni at webmd.net> wrote:
>
>     > I have been trying to figure how can I configure PgPool with one
> primary
>     > and one hot-standby slave to route read-requests to hot-standby when
>     > primary is down without any failover. Is it currently possible?
> Please
>     > don't ask why.
>     >
>     > Thank you,
>     > Andre Piwoni
>
>
>     --
>     Bo Peng <pengbo at sraoss.co.jp>
>     SRA OSS, Inc. Japan
>
>     _______________________________________________
>     pgpool-general mailing list
>     pgpool-general at pgpool.net
>     http://www.pgpool.net/mailman/listinfo/pgpool-general
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20180620/3e0daca1/attachment.htm>