Hello.
When you execute pg_stop_backup,postgresql makes a special file, like this
00010015.0064.backup.
This means you can delete wal 00010014 and before.
The PostgreSQL manual also says following.
http://www.postgresql.org/docs/8.4/interactive/continuous-ar
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 conn
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
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@postgresql.org)
To make changes to your subscri
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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
erobles wrote:
which is the right procedure to clean wal files after a recovery ??
which kind of recovery ? PITR or just a crash ?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
which is the right procedure to clean wal files
after a recovery ??
