*slave_new:* server that needs a new copy of the DB *slave01:* streaming replication slave
*My steps are:* *1.* ssh slave_new *2.* Stop postgres *3.* rm -rf /var/lib/pgsql/9.2/data/* *4.* ssh postgres@slave01 'pg_basebackup --pgdata=- --format=tar --label=slave_new --progress --host=localhost --port=5432 --username=replicator --xlog-method=stream' | tar -x --no-same-owner *5. *Once the STEP 4 is done, copy the original postgresql.conf pg_hba.conf recovery.conf into /var/lib/pgsql/9.2/data *6. *Set recovery,conf with restored command. *7. *Start Postgres I should be able to see the DB recovering itself from the wal_files via LOGS Is that right?
