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