Re: Problem with archive_command - Mailing list pgsql-general

From Merlin Moncure
Subject Re: Problem with archive_command
Date
Msg-id b42b73150607140818r675179e6w7bc0e128400bd046@mail.gmail.com
Whole thread Raw
In response to Antw: Problem with archive_command  ("Christian Rengstl" <Christian.Rengstl@klinik.uni-regensburg.de>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Timestamp vs timestamptz
Next
From: Tom Lane
Date:
Subject: Re: databases hidden in phppgadmin