Re: cleaning wal files from postgres

oops, sorry, my question was very ambiguous ...
What I want to know is:
The correct procedure to remove the wal files that have been used  in
the recovery of a postgres server.


Consider the following;

1.-  A main server in production.
2.- A  secondary server that is normally off.
3.-  By connecting the secondary server, the primary server must copy
the  directory data as well as wal files generated during the copying
process.

4.- start up  the postgres on the secondary server.

5o.Delete wal  files no longer will be used by postgres to save disk space.

  how can i know which  wal file is not required by postgres and
delete   wal files from  main and secondary server, to save space disk
on the servers ? (after a succesfully start up on secondary server)


regards eddie.

On 05/21/2010 03:43 PM, Andreas Schmitz wrote:
>
> maybe I don't understand the problem. there is no need to clean WAL
> files after recovery. where exactly is the problem ?
>
> regards
>
> andreas
>
>
> erobles wrote:
>>
>>  PITR  recovery
>>
>> On 05/21/2010 03:04 PM, Andreas Schmitz wrote:
>>> erobles wrote:
>>>> which is the right procedure to clean wal files after a  recovery ??
>>> what kind of recovery ?
>>>
>>> regards
>>>
>>> andreas
>>>
>>
>
>