Re: Turning slave into a master - PostgreSQL 9.2

[Patrick B <patrickbakerbr@xxxxxxxxx>]

2016-11-02 8:43 GMT+13:00 Patrick B <patrickbakerbr@xxxxxxxxx>:

2016-11-02 2:55 GMT+13:00 Scott Marlowe <scott.marlowe@xxxxxxxxx>:

On Mon, Oct 31, 2016 at 8:01 PM, Patrick B <patrickbakerbr@xxxxxxxxx> 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 replica setup. In 9.2 you
gotta make your own recovery.conf, but you already know how to do
that. Way easier than trying to rsync by hand etc.

I did a pg_basebackup!

Hi guys,

I was able to fix it doing:

recovery.conf:

restore_command = 'cp /var/lib/pgsql/archive/%f %p'
recovery_target_timeline = 'latest'
standby_mode = off
trigger_file = '/tmp/pg_failover_trigger'

Then, I got the error:

FATAL:  archive file "00000002000019D5000000EC" has wrong size: 0 instead of 16777216

To fix it:

rm 00000002000019D5000000EC

Restart postgres and then:

 LOG:  archive recovery complete
LOG:  database system is ready to accept connections