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