Um dia desses meu slave deu pau..Recriei assim..Seguintes passos.
*Servidor master*
Su - postgres
1 - Inicializa o Backup
/usr/local/pgsql/bin/psql -c "SELECT pg_start_backup('replication');"
2 - Envia através do rsync a copia das bases e arquivos do master
rsync -av --exclude pg_xlog --exclude postgresql.conf --exclude
postmaster.pid /postgresql/data/ 10.1.3.117:/postgresql/data/
3 - Para o backup
/usr/local/pgsql/bin/psql -c "SELECT pg_stop_backup();"
*Servidor Slave*
1 - Copia os scripts preconfigurados para replicação
cd ../scripts_replication/
cp pg_hba.conf postgresql.conf recovery.conf /postgresql/data/
2 - Recria a pasta pg_xlog do slave
cd /postgresql/data
mkdir -p pg_xlog (necessário criar manualmente)
3 - Inicializa o Banco
/etc/init.d/rc.postgresql start
4- Para monitorar abrir outro terminal e verificar o arquivo serverlog
tail -f serverlog
LOG: replication connection authorized: user=postgres host=10.1.3.117
port=42646
Senha:
LOG: database system was interrupted; last known up at 2011-10-10 10:26:43
BRT
FATAL: required WAL directory "pg_xlog" does not exist
LOG: startup process (PID 6220) exited with exit code 1
LOG: aborting startup due to startup process failure
Senha:
LOG: database system was interrupted; last known up at 2011-10-10 10:26:43
BRT
LOG: creating missing WAL directory "pg_xlog/archive_status"
LOG: entering standby mode
LOG: restored log file "000000010000000000000033" from archive
LOG: redo starts at 0/33000020
LOG: consistent recovery state reached at 0/34000000
LOG: database system is ready to accept read only connections
cp: impossível obter estado de
"/home/postgres/replication/000000010000000000000034": Arquivo ou diretório
não encontrado
LOG: streaming replication successfully connected to primary
Emerson Martins
DBA Jr
Itec/AL
82 9123-5504
82 9668-1283
Em 11 de janeiro de 2012 19:14, william felipe_welter
<[email protected]>escreveu:
> Este rsync ficou entre um pg_start_backup e pg_stop_backup ?
> O archive_mode esta on no master ?
>
> Em 11 de janeiro de 2012 18:25, Dauro Sobrinho
> <[email protected]> escreveu:
> > rsync -av --exclude postmaster.pid --exclude postgresql.conf --exclude
> > pg_hba.conf --exclude backup_label --exclude pg_xlog/*
> > --exclude pg_log/* /bd/primario/ [email protected]:/bd/secundario
> >
> >
> >
> >
> > Em 11 de janeiro de 2012 17:21, Flavio Henrique Araque Gurgel
> > <[email protected]> escreveu:
> >
> >> > Postgresql - Principal
> >> >
> >> > listen_addresses = '*'
> >> > wal_level = hot_standby
> >> >
> >> >
> >> > max_wal_senders = 1
> >> > wal_keep_segments = 40
> >> >
> >> >
> >> >
> >> > Postgresql - Secundário
> >> > hot_standby=on
> >> >
> >> > Recovery - Secundário
> >> >
> >> >
> >> > standby_mode = on
> >> > primary_conninfo = 'host=ip_number port=port_number user=user
> >> > password=pass'
> >> > trigger_file = '/path/failover.trg'
> >>
> >> Como você fez a cópia do cluster? Usou pg_basebackup ou fez na mão?
> >> Se na mão, como fez?
> >>
> >> []s
> >> Flavio Gurgel
> >> _______________________________________________
> >> pgbr-geral mailing list
> >> [email protected]
> >> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
> >
> >
> >
> >
> > --
> > Att,
> >
> > Dauro Lima Sobrinho
> > DBA PostgreSQL
> > DB2 Database Administrator for LUW - IBM Information Management
> > DB2 Certified Database Associate - IBM Information Management
> > DB2 Technical Mastery v2 - IBM Information Management
> > Informix Dynamic Server - IBM Information Management
> > SQL Server 2008 - Microsoft Certified Technology Specialist
> >
> >
> > _______________________________________________
> > pgbr-geral mailing list
> > [email protected]
> > https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
> >
>
>
>
> --
> William Felipe Welter
> ------------------------------
> Consultor em Tecnologias Livres
> [email protected]
> www.4linux.com.br
> _______________________________________________
> pgbr-geral mailing list
> [email protected]
> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
>
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
