What is the best method for WAL log transfer on Windows?

I have two servers with Windows Server 2008, PostgreSQL 9.0 64bit.

Servers do not have any shared SAN disk, they are on different hosts, different subnets.

Files from the first server must be transferred in reliable way to the second server.

Archive location must be protected by password.

I have tried to use free rsync/rsyncd solution called DeltaCopy, but permissions part is hard for me. The service does not want to run under "postgres" account. It runs as System Local acount but the files are not readable by postgres. If I use incoming chmod option in deltacd.conf (aka rsyncd.conf), it "garbles" Windows file permissions, so I have problems with some actions on file's "Security" tab.

I would like some solution which is reliable, and easy to setup and maintain.

One respondent suggested xcopy - but it has no option to provide passowrd from command line or password file.



1 Answer 1


Have you considered Robocopy? It is able to copy NTFS ACLs. I guess you might need to have postgres running under the same Domain Account on source and target if possible but I'm probably out of my depth talking about such things.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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