Re: [GENERAL] Turning slave into a master - PostgreSQL 9.2

2016-11-01 Thread Scott Marlowe
On Tue, Nov 1, 2016 at 1:43 PM, Patrick B wrote: > > > 2016-11-02 2:55 GMT+13:00 Scott Marlowe : >> >> On Mon, Oct 31, 2016 at 8:01 PM, Patrick B >> wrote: >> > If I change recovery.conf: >> > >> > recovery_target_time

Re: [GENERAL] Turning slave into a master - PostgreSQL 9.2

2016-11-01 Thread Patrick B
2016-11-02 8:43 GMT+13:00 Patrick B : > > > 2016-11-02 2:55 GMT+13:00 Scott Marlowe : > >> On Mon, Oct 31, 2016 at 8:01 PM, Patrick B >> wrote: >> > If I change recovery.conf: >> > >> > recovery_target_time =

Re: [GENERAL] Turning slave into a master - PostgreSQL 9.2

2016-11-01 Thread Patrick B
2016-11-02 2:55 GMT+13:00 Scott Marlowe : > On Mon, Oct 31, 2016 at 8:01 PM, Patrick B > wrote: > > If I change recovery.conf: > > > > recovery_target_time = '2016-10-30 02:24:40' > > > > > > I get error: > > > > FATAL: requested recovery stop

Re: [GENERAL] Turning slave into a master - PostgreSQL 9.2

2016-11-01 Thread Scott Marlowe
On Mon, Oct 31, 2016 at 8:01 PM, Patrick B wrote: > If I change recovery.conf: > > recovery_target_time = '2016-10-30 02:24:40' > > > I get error: > > FATAL: requested recovery stop point is before consistent recovery point You can try using pg_basebackup to get the

Re: [GENERAL] Turning slave into a master - PostgreSQL 9.2

2016-11-01 Thread Francisco Olarte
Hi: On Tue, Nov 1, 2016 at 3:01 AM, Patrick B wrote: > If I change recovery.conf: > recovery_target_time = '2016-10-30 02:24:40' > I get error: > FATAL: requested recovery stop point is before consistent recovery point It looks clear. When you take a base backup from

Re: [GENERAL] Turning slave into a master - PostgreSQL 9.2

2016-10-31 Thread Patrick B
If I change recovery.conf: recovery_target_time = '2016-10-30 02:24:40' I get error: FATAL: requested recovery stop point is before consistent recovery point

Re: [GENERAL] Turning slave into a master - PostgreSQL 9.2

2016-10-31 Thread Patrick B
I actually want to restore in a point of time. Don't want to recovery_target_timeline = 'latest' How can I stipulate a date? Thanks 2016-11-01 11:59 GMT+13:00 Patrick B : > > > 2016-11-01 10:33 GMT+13:00 David G. Johnston : > >> On Mon,

Re: [GENERAL] Turning slave into a master - PostgreSQL 9.2

2016-10-31 Thread Patrick B
2016-11-01 10:33 GMT+13:00 David G. Johnston : > On Mon, Oct 31, 2016 at 1:46 PM, Patrick B > wrote: > >> Hi guys, >> >> I got a test server, let's call it test01. >> >> The test01 has a basebackup from the master. >> I want to turn test01

Re: [GENERAL] Turning slave into a master - PostgreSQL 9.2

2016-10-31 Thread David G. Johnston
On Mon, Oct 31, 2016 at 1:46 PM, Patrick B wrote: > Hi guys, > > I got a test server, let's call it test01. > > The test01 has a basebackup from the master. > I want to turn test01 into a master. It doesn't need to catch up with the > wal_files, because I don't need it

[GENERAL] Turning slave into a master - PostgreSQL 9.2

2016-10-31 Thread Patrick B
Hi guys, I got a test server, let's call it test01. The test01 has a basebackup from the master. I want to turn test01 into a master. It doesn't need to catch up with the wal_files, because I don't need it to be up-to-date. So what I did is: - Replaced /var/lib/pgsql/9.2/data/ with the