I have Postgresql 11 running on Windows server and master/slave replication working perfectly.

I have enable the wal_archiving and also i have enabled automatic backups using pg_dump

I need to ask if point in time recovery is possible on Windows and steps to perform it.

  • 1
    Yes it's possible, but pg_dump is not the tool for that. You need to use pg_basebackup as documented in the manual. The steps are the same on Windows – a_horse_with_no_name Jul 13 '20 at 13:46
  • (Please switch from the term "Slave" to "Replica".) – Rick James Jul 15 '20 at 0:22

Your Answer

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

Browse other questions tagged or ask your own question.