Postgres Pro
Downloads
Home   >   mailing lists

Re: Missing wal_files Postgres 9.2 - Mailing list pgsql-admin

From Patrick B
Subject Re: Missing wal_files Postgres 9.2
Date
Msg-id CAJNY3isM7hpP7p8Ks2KR2YAZCjLms1EtkFe9DUE12jKekVGcaQ@mail.gmail.com
Whole thread Raw
In response to Re: Missing wal_files Postgres 9.2  (Patrick B <patrickbakerbr@gmail.com>)
List pgsql-admin
Tree view
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?

pgsql-admin by date:

Previous
From: Patrick B
Date:
Subject: Re: Missing wal_files Postgres 9.2
Next
From: "Ferrell, Denise SDC"
Date:
Subject: Postgres v9.6