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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
