postgresql Wal backup

Walter Grimm
Walter Grimm used Ask the Experts™
on
I am running Wal backup, I am looking for the correct string for pg configuration files, that will copy my last successful Wal backup files to another local directory,  

bu wal is running fine  minutely, I now need to have the finalized files pushed for pg to another dir, if I monitor the wal dir, and move some files, that are still active somehow, pg will crash
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
lcohanDatabase Analyst

Commented:
Would this https://support.qasymphony.com/hc/en-us/articles/360006834212-Continuous-WAL-Archiving-for-Windows help?
Please have a look in particular at:
# This is the command to invoke for each WAL file to be archived.
archive_command = 'copy "%p" "D:\\pgarchive\\%f"'

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial