| From: | "Christian Rengstl" <Christian(dot)Rengstl(at)klinik(dot)uni-regensburg(dot)de> |
|---|---|
| To: | <mmoncure(at)gmail(dot)com>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Antw: Re: Problem with archive_command |
| Date: | 2006-07-14 15:28:15 |
| Message-ID: | 44B7D42F020000800003D8C5@rrzgw1.uni-regensburg.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)gmail(dot)com> 14.07.06 17.18 Uhr >>>
On 7/14/06, Christian Rengstl
<Christian(dot)Rengstl(at)klinik(dot)uni-regensburg(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2006-07-14 15:29:15 | Re: Is there a way to run tables in RAM? |
| Previous Message | Martijn van Oosterhout | 2006-07-14 15:27:03 | Re: Antw: Problem with archive_command |