Thread: BUG #10817: archive settings

BUG #10817: archive settings

From
rameshparnanditech@gmail.com
Date:
The following bug has been logged on the website:

Bug reference:      10817
Logged by:          Ramesh
Email address:      rameshparnanditech@gmail.com
PostgreSQL version: 9.3.3
Operating system:   windows 7
Description:

hi i'm new postgres.

when try to set archive_command in postgres.conf

like,
archive_command = 'copy "%p" "C:\Program Files\PostgreSQL\9.3\testdata\%f"'

then  ran this query pg_stop_backup();

its return error like,
wait for wal segments to archive 60 seconds please check archive command..
following error retunrs

Re: BUG #10817: archive settings

From
Michael Paquier
Date:
On Mon, Jun 30, 2014 at 10:01 PM, <rameshparnanditech@gmail.com> wrote:

> when try to set archive_command in postgres.conf
>
This is not a bug, it is better to ask such questions in pgsql-general or
pgsql-novice.


> like,
> archive_command = 'copy "%p" "C:\Program Files\PostgreSQL\9.3\testdata\%f"'
>
I recall that the use of double backslash "\\" is necessary to indicate the
folder path, making the command look like that actually:
archive_command = 'copy "%p" "C:\\Program
Files\\PostgreSQL\\9.3\\testdata\\%f"'

then  ran this query pg_stop_backup(); its return error like,
> wait for wal segments to archive 60 seconds please check archive command..
> following error retunrs
>
Without more details about the failure, we cannot guess what is happening?
Is it a permission issue? Does the target folder exist?
--
Michael