Postgres Pro
Downloads
Home   >   mailing lists

Re: Stream Replication archive command Access is denied question - Mailing list pgsql-general

From tuanhoanganh
Subject Re: Stream Replication archive command Access is denied question
Date
Msg-id AANLkTinZZkmKGxp62eFJHR4FdYny11BsZizOCqdA0zhO@mail.gmail.com
Whole thread Raw
In response to Re: Stream Replication archive command Access is denied question  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
Tree view
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@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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: Stream Replication archive command Access is denied question
Next
From: Esmin Gracic
Date:
Subject: query_to_xml function ignores Datestyle?