Re: Missing wal_files Postgres 9.2

slave_new: server that needs a new copy of the DB

slave01: streaming replication slave

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

Is that right?