From: | Patrick B <patrickbakerbr(at)gmail(dot)com> |
---|---|
To: | Keith <keith(at)keithf4(dot)com> |
Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Missing wal_files Postgres 9.2 |
Date: | 2016-07-04 01:50:55 |
Message-ID: | CAJNY3isM7hpP7p8Ks2KR2YAZCjLms1EtkFe9DUE12jKekVGcaQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
*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(at)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?
From | Date | Subject | |
---|---|---|---|
Next Message | Ferrell, Denise SDC | 2016-07-05 13:23:09 | Postgres v9.6 |
Previous Message | Patrick B | 2016-07-04 00:17:17 | Re: Missing wal_files Postgres 9.2 |