Antw: Re: Problem with archive_command

Started by Christian Rengstlover 19 years ago1 messagesgeneral
Jump to latest
#1Christian Rengstl
Christian.Rengstl@klinik.uni-regensburg.de

i made a pg_dump. Maybe it would help to delete the files in the
pg_xlog/archive_status directory...anyway the server just has a sandbox
status so far.

"Merlin Moncure" <mmoncure@gmail.com> 14.07.06 17.18 Uhr >>>

On 7/14/06, Christian Rengstl
<Christian.Rengstl@klinik.uni-regensburg.de> wrote:

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

you deleted wal files out of pg_xlog from a running server? have a
recent backup?

merlin