Thread: WAL FILE DELETED

WAL FILE DELETED

From
"Gaetano Mendola"
Date:
Hi to all,

I increased the parameter wal_file to 64 and the disk was
not enough :-( !!!!

So I stopped the postgres I removed all content of the directory pg_xlog
and I tried to restart the postgres but .... not start anymore ...
any idea how recreate the wall files (now are 16) or say: "start with a wall
file from the scratch" ?



Ciao
Gaetano

--
#exclude <windows>
#include <CSRSS>
printf("\t\t\b\b\b\b\b\b");.
printf("\t\t\b\b\b\b\b\b");


Re: WAL FILE DELETED

From
"Gaetano Mendola"
Date:
I wrote:

> Hi to all,
>
> I increased the parameter wal_file to 64 and the disk was
> not enough :-( !!!!
>
> So I stopped the postgres I removed all content of the directory pg_xlog
> and I tried to restart the postgres but .... not start anymore ...
> any idea how recreate the wall files (now are 16) or say: "start with a
wall
> file from the scratch" ?


I used contrib/pg_resetxlog and I solved my problem.

Ciao
Gaetano