NAME

       pcp_promote_node - promotes the given node as new master to Pgpool-II

SYNOPSIS

       pcp_promote_node [options...] [node_id] [gracefully]

DESCRIPTION

       pcp_promote_node promotes the given node as new master to Pgpool-II. In master/slave
       streaming replication only. Please note that this command does not actually promote
       standby PostgreSQL backend: it just changes the internal status of Pgpool-II and trigger
       failover and users have to promote standby PostgreSQL outside Pgpool-II.

       pcp_promote_node executes followings. Please be warned that if follow_master_command is
       set, the command will be executed. It is a standard advice that you disable
       follow_master_command before executing this command.

        1. Change the status of standby PostgreSQL from standby to primary. It just changes the
           internal status of Pgpool-II and it does not actually promote PostgreSQL standby
           server.

        2. Change the status of PostgreSQL node which is not specified by this command's argument
           to down. It just changes the internal status of Pgpool-II and it does not actually
           make PostgreSQL standby server down.

        3. If follow_master_command is set, execute follow_master_command against PostgreSQL.

OPTIONS

       -n node_id
       --node-id=node_id
           The index of backend node to promote as new master.

       -g
       --gracefully
           Wait until all clients are disconnected (unless client_idle_limit_in_recovery is -1 or
           recovery_timeout is expired).

       Other options
           See pcp_common_options(1).