Is by any chance D: a network mapped drive in Windows ? No, D is a driver on master computer. I can copy 000000010000000300000056 file from postgresql data\pg_xlog to D:/3SDATABACKUP/PITR
On Sat, Jan 1, 2011 at 4:30 PM, John R Pierce <pie...@hogranch.com> wrote: > 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. > > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
