rsync -av --exclude postmaster.pid --exclude postgresql.conf --exclude
pg_hba.conf --exclude backup_label --exclude pg_xlog/*
--exclude pg_log/* /bd/primario/ postgres@10.1.1.2:/bd/secundario



Em 11 de janeiro de 2012 17:21, Flavio Henrique Araque Gurgel <
fha...@gmail.com> 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
> pgbr-geral@listas.postgresql.org.br
> 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
pgbr-geral@listas.postgresql.org.br
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral

Responder a