>
> >To: Comunidade PostgreSQL Brasileira
> > <[email protected]>
> >Message-ID:
> > <
> cajghg4+tjro+_orzsy-4q+go7dks0tidez0wyeajca2kvk4...@mail.gmail.com>
> >Content-Type: text/plain; charset="iso-8859-1"
>
> >O que tem no arquivo "/usr/pgpool-9.1/bin/failover_stream.sh"??
>
> --
> >Matheus de Oliveira
>
> Matheus,
O acesso via ssh ja esta ok entre os servidores e verifiquei que o arquivo
foi alterado no outro servidor.
Segue o arquivo:
more failover_stream.sh
#! /bin/sh
# Failover command for streaming replication.
# This script assumes that DB node 0 is primary, and 1 is standby.
#
# If standby goes down, do nothing. If primary goes down, create a
# trigger file so that standby takes over primary node.
#
# Arguments: $1: failed node id. $2: new master hostname. $3: path to
# trigger file.
failed_node=$1
new_master=$2
trigger_file=$3
# Do nothing if standby goes down.
if [ $failed_node = 1 ]; then
exit 0;
fi
# Create the trigger file.
/usr/bin/ssh -T $new_master /bin/touch $trigger_file
exit 0;
> Antonio Abner Junior - AJ
>
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral