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

Wolf Schwurack wolf at uen.org
Thu Jun 21 00:40:15 JST 2018


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
    



More information about the pgpool-general mailing list