BUG #10817: archive settings
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
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
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