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
<pierce@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