Re: Stream Replication archive command Access is denied question

On 01/01/11 1:23 AM, tuanhoanganh wrote:
> archive_command = 'copy %p D:/3SDATABACKUP/PITR/WAL/%f' #
> command to use to archive a logfile segment
> ...
> 2011-01-01 10:14:19 ICT LOG: archive command failed with exit code 1
> 2011-01-01 10:14:19 ICT DETAIL: The failed archive command was: copy
> "pg_xlog\000000010000000300000056"
> "D:\3SDATABACKUP\PITR\WAL\000000010000000300000056"
> Access is denied.

Is by any chance D: a network mapped drive in Windows ?

drive mappings are by user session. the postgres service is running in
a different user session than your interactive desktop session, so your
desktop shared drives mean nothing to it.

if you're copying across the network, use the UNC name, like

archive_command = 'copy %p
//servername/sharename/3SDATABACKUP/PITR/WAL/%f' # command to use
to archive a logfile segment

and make sure that on the server, there is a postgres user with the same
password as the service account. or, if you are in an active directory
environment, use a domain account to run the service.