Re: BAKUP ISSUE

[dinesh kumar <dineshkumar02@xxxxxxxxx>]

Hi,

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