Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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.

thanks

share|improve this question

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.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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