Re: BAKUP ISSUE - Mailing list pgsql-general

From dinesh kumar
Subject Re: BAKUP ISSUE
Date
Msg-id CALnrH7qdjxh24xampq5_dBegvWzgRSmF3keY9skZ0qb4q6q6Xw@mail.gmail.com
Whole thread Raw
In response to Re: BAKUP ISSUE  (hubert depesz lubaczewski <depesz@gmail.com>)
List pgsql-general
Hi,

On Wed, Jul 9, 2014 at 2:43 PM, Ramesh T <rameshparnanditech@gmail.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

pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: php password authentication failed for user ...
Next
From: hubert depesz lubaczewski
Date:
Subject: Re: BAKUP ISSUE