From: | "Christian Rengstl" <Christian(dot)Rengstl(at)klinik(dot)uni-regensburg(dot)de> |
---|---|
To: | "Christian Rengstl" <Christian(dot)Rengstl(at)klinik(dot)uni-regensburg(dot)de>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Antw: Problem with archive_command |
Date: | 2006-07-14 13:22:43 |
Message-ID: | 44B7B6C3020000800003D89C@rrzgw1.uni-regensburg.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi list,
well now i know why it doesn't work. As the copy command did not work
for a while the wal-files where gathering like mad and, as a beginner, i
thought in order to clean up some disk space i should delete them. Well,
that was probably the most stupid thing to do, because now pgsql tries
to copy non-existing wal-files back and forth, which, as you might
imagine, does not work very well. Is there a way to reset pgsql
regarding the wal files and to tell it to start all over again to make
wal files? I tried to restart the server, but without success.
Please help
Chris
>>> "Christian Rengstl" <Christian(dot)Rengstl(at)klinik(dot)uni-regensburg(dot)de>
14.07.06 14.29 Uhr >>>
Hi list,
with the following archive_command (on Windows) archive_command = 'copy
%p c:\\Archiv\\DBArchiv\\%f' I constantly have entries like the
following in my log file:
2006-07-14 14:26:59 LOG: archive command "copy
pg_xlog\000000010000000200000037
c:\Archiv\DBArchiv\000000010000000200000037" failed: return code 1
2006-07-14 14:27:00 LOG: archive command "copy
pg_xlog\000000010000000200000037
c:\Archiv\DBArchiv\000000010000000200000037" failed: return code 1
2006-07-14 14:27:01 LOG: archive command "copy
pg_xlog\000000010000000200000037
c:\Archiv\DBArchiv\000000010000000200000037" failed: return code 1
2006-07-14 14:27:01 WARNING: transaction log file
"000000010000000200000037" could not be archived: too many failures
Thanks for any advice!
Chris
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
From | Date | Subject | |
---|---|---|---|
Next Message | Merlin Moncure | 2006-07-14 13:59:19 | Re: Performance problem with query |
Previous Message | Shoaib Mir | 2006-07-14 13:05:44 | Re: table replication, without master-slave setup |