Re: Antw: Problem with archive_command

On Fri, Jul 14, 2006 at 03:22:43PM +0200, Christian Rengstl 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.

pg_resetxlog might get you out of your current woes. But yeah, that was
a pretty dumb thing to do. Got a backup?

Have a nice dat,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.