Re: Missing wal_files Postgres 9.2

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?

In response to

Browse pgsql-admin by date

  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