Search Postgresql Archives

Antw: Re: Problem with archive_command

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

 



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@xxxxxxxxx> 14.07.06 17.18 Uhr >>>
On 7/14/06, Christian Rengstl
<Christian.Rengstl@xxxxxxxxxxxxxxxxxxxxxxxx> 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



[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