General discussion

tuanhoanganh | 1 Jan 2011 10:50

Re: Stream Replication archive command Access is denied question

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

headers

John R Pierce | 1 Jan 2011 11:18

Re: Stream Replication archive command Access is denied question

On 01/01/11 1:50 AM, tuanhoanganh wrote:
> 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

does the postgres service account have write access to that directory ?

check the access control lists on the directory and parents.  note that 
postgres might NOT be a member of 'Users' or other generic groups

--

-- 
Sent via pgsql-general mailing list (pgsql-general <at> postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

headers

tuanhoanganh | 1 Jan 2011 11:27

Re: Stream Replication archive command Access is denied question

Thanks in advance.
When I share D:/3SDATABACKUP/PITR on master computer, I set account postgres only read when access \\192.168.5.4\pitr but directory sercurity of D:/3SDATABACKUP/PITR user postgers has been changed to read only. I had changed directory sercurity of D:/3SDATABACKUP/PITR user postgers to full access. Everything work fine.

Thanks you very much. Sorry for my English.

Tuan Hoang ANh.

On Sat, Jan 1, 2011 at 5:18 PM, John R Pierce <pierce <at> hogranch.com> wrote:

On 01/01/11 1:50 AM, tuanhoanganh wrote:
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

does the postgres service account have write access to that directory ?

check the access control lists on the directory and parents. note that postgres might NOT be a member of 'Users' or other generic groups

--
Sent via pgsql-general mailing list (pgsql-general <at> postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general