Search Postgresql Archives

Re: BAKUP ISSUE

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



hi,  
      Yes,not an error it is a warning  and archive is working.
  when i archivelog is on in postgresql.conf .

when try to run below statement its return warning and HINT:  Check that your archive_command is executing properly

like below ..
postgres=# select pg_stop_backup();

 it is going on 60 seconds,120 seconds 240 seconds,480 seconds ....and so when it  is going stop and gets completed.

it is taking too much of time but not completing,what i should i do..

           
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.

WARNING:  pg_stop_backup still waiting for all required WAL segments to be archi
ved (120 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 path c:\program files\postgresql\9.3\data\pg_xlog TO c:\program files\postgresql\ramesh
no files  in c:\program files\postgresql\ramesh 

in pg log it say 


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

please let me know what should i do,how to set the archive command in windows.

thanks in advance
ramesh



On Wed, Jul 9, 2014 at 6:23 PM, hubert depesz lubaczewski <depesz@xxxxxxxxx> wrote:
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@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.

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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux