1

I am getting below error while restoring Postgres instance to a point in time.

FATAL:  requested recovery stop point is before consistent recovery point

below is my recovery.conf content

restore_command = 'cp /var/lib/pgsql/pg_log_archive/%f %p'
recovery_target_time = '2018-04-17 10:56:27'
recovery_target_inclusive = false

I want to restore postgreSQL instance to a specified time.What am I doing wrong here?

1

You need to start with an earlier base backup than the one you are currently starting from. PostgreSQL can only recover forward, not backward.

  • I also reached on the same conclusion after some googling. – Python Apr 17 '18 at 19:23

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.