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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
