Re: BAKUP ISSUE

Hi,

On Wed, Jul 9, 2014 at 2:43 PM, Ramesh T <rameshparnanditech(at)gmail(dot)com>
> wrote:
>
>> i rune problem is when i run the pg_stop_backup() its return error in
>> this way
>>
>> postgres=# select pg_stop_backup();
>>
>>
>> *NOTICE: pg_stop_backup cleanup done, waiting for required WAL segments
>> to be ar*
>> *chived*
>> *WARNING: pg_stop_backup still waiting for all required WAL segments to
>> be archi*
>> *ved (60 seconds elapsed)*
>> *HINT: Check that your archive_command is executing properly.
>> pg_stop_backup ca*
>> *n be canceled safely, but the database backup will not be usable without
>> all the*
>> * WAL segments.*
>>
> i changed in postgresql.conf to archive_command = 'copy "%p" "C:\Program
>> Files\PostgreSQL\ramesh %f"' still working same error return..
>>
>
I believe, you have to give the archive_command in windows like below, due
to window's escape sequences behavior.

'copy "%p" "C:\\\\Program Files\\\\PostgreSQL\\\\<Archive Location, where
postgreSQL Instance owner has the permission>\\\\%f " '

Regards,
Dinesh
manojadinesh.blogspot.com