Re: BAKUP ISSUE

From: Marc Watson <mark(dot)watson(at)jurisconcept(dot)ca>
To: hubert depesz lubaczewski <depesz(at)gmail(dot)com>, Ramesh T <rameshparnanditech(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: BAKUP ISSUE
Date: 2014-07-10 12:25:03
Message-ID: 02F1BBB48ABD3245A3BC519B57CFC8CA5DB41452@Exchange.JurisConcept.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

De : pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)org] De la part de hubert depesz lubaczewski
Envoyé : July-09-14 9:55 AM

On Wed, Jul 9, 2014 at 3:28 PM, Ramesh T <rameshparnanditech(at)gmail(dot)com<mailto:rameshparnanditech(at)gmail(dot)com>> wrote:
Yes,not an error it is a warning and archive is working.

How can you say that archive is working when in logs you have?

2014-07-09 18:53:33 IST LOG: archive command failed with exit code 1
2014-07-09 18:53:33 IST DETAIL: The failed archive command was: copy "pg_xlog\000000010000000000000001" "C:Program FilesPostgreSQL
amesh 000000010000000000000001"
2014-07-09 18:53:34 IST LOG: archive command failed with exit code 1
2014-07-09 18:53:34 IST DETAIL: The failed archive command was: copy "pg_xlog\000000010000000000000001" "C:Program FilesPostgreSQL
amesh 000000010000000000000001"
2014-07-09 18:53:34 IST WARNING: archiving transaction log file "000000010000000000000001" failed too many times, will try again later

Fix the archive command so that it will actually work (files should appear in destination directory).
I have 0 knowledge about windows, but I would guess you need to use \\ and not \ in the path. Also - does the destination path exist?
depesz

Also, on windows, one can use the forward slash ‘/’ instead of the backslash in a path
Just my 2 cents.
-Mark

In response to

Browse pgsql-general by date

  From Date Subject
Next Message AlexK 2014-07-10 14:59:20 Should I partition this table?
Previous Message Ken Tanzer 2014-07-10 12:03:10 Re: php password authentication failed for user ...