Обсуждение: Re: BAKUP ISSUE
HI,I have a problem when i take backup using pg_basebackup and pg_start_backup('base');following ,
archive_mode = onarchive_command = 'copy "%p" "C:\\Program Files\\PostgreSQL\\9.3\\data\\pg_xlog\\%f"'
Is c:\program files\postgresql\9.3\data\pg_xlog directory for xlog for THIS postgresql?
First - do not take the messages off list. Someone else might be able to help you if you'll mail to the list, I'm not always there, and others might have better ideas.
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 waypostgres=# select pg_stop_backup();NOTICE: pg_stop_backup cleanup done, waiting for required WAL segments to be archivedWARNING: pg_stop_backup still waiting for all required WAL segments to be archived (60 seconds elapsed)HINT: Check that your archive_command is executing properly. pg_stop_backup can be canceled safely, but the database backup will not be usable without all theWAL segments.
This is just notice and a warning.
i changed in postgresql.conf to archive_command = 'copy "%p" "C:\Program Files\PostgreSQL\ramesh %f"' still working same error return..
depesz
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 waypostgres=# select pg_stop_backup();NOTICE: pg_stop_backup cleanup done, waiting for required WAL segments to be archivedWARNING: pg_stop_backup still waiting for all required WAL segments to be archived (60 seconds elapsed)HINT: Check that your archive_command is executing properly. pg_stop_backup can be canceled safely, but the database backup will not be usable without all theWAL segments.i changed in postgresql.conf to archive_command = 'copy "%p" "C:\Program Files\PostgreSQL\ramesh %f"' still working same error return..
Dinesh
Yes,not an error it is a warning and archive is working.
2014-07-09 18:53:33 IST LOG: archive command failed with exit code 12014-07-09 18:53:33 IST DETAIL: The failed archive command was: copy "pg_xlog\000000010000000000000001" "C:Program FilesPostgreSQLamesh 000000010000000000000001"2014-07-09 18:53:34 IST LOG: archive command failed with exit code 12014-07-09 18:53:34 IST DETAIL: The failed archive command was: copy "pg_xlog\000000010000000000000001" "C:Program FilesPostgreSQLamesh 000000010000000000000001"2014-07-09 18:53:34 IST WARNING: archiving transaction log file "000000010000000000000001" failed too many times, will try again later
Hi,
First - do not take the messages off list. Someone else might be able to help you if you'll mail to the list, I'm not always there, and others might have better ideas.
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 waypostgres=# select pg_stop_backup();NOTICE: pg_stop_backup cleanup done, waiting for required WAL segments to be archivedWARNING: pg_stop_backup still waiting for all required WAL segments to be archived (60 seconds elapsed)HINT: Check that your archive_command is executing properly. pg_stop_backup can be canceled safely, but the database backup will not be usable without all theWAL segments.But there is no ERROR?! What error are you talking about?
This is just notice and a warning.i changed in postgresql.conf to archive_command = 'copy "%p" "C:\Program Files\PostgreSQL\ramesh %f"' still working same error return..What error? So far you didn't show any.Is the archiving working? Are there files in c:\program files\postgresql\ramesh ?If not, what does pg logs say about archiving? Any errors there?
depesz
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?
Michael
De : pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.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@gmail.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