From: | erobles <erobles(at)sensacd(dot)com(dot)mx> |
---|---|
To: | |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: cleaning wal files from postgres |
Date: | 2010-05-24 14:41:37 |
Message-ID: | 4BFA9021.9010605@sensacd.com.mx |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
>>>
>>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Ken Winter | 2010-05-24 17:06:28 | Re: ROLLBACK in a function |
Previous Message | ritas | 2010-05-24 14:22:19 | can't install postgres 8.4 on windows 2003 server |