From: | "f\(dot)guidi\(at)libero\(dot)it" <f(dot)guidi(at)libero(dot)it> |
---|---|
To: | "pgsql-admin" <pgsql-admin(at)postgresql(dot)org> |
Subject: | backup and wal files |
Date: | 2005-12-14 09:57:38 |
Message-ID: | IRHFO2$750AAB7343D67ACD2DBE3C72F501E54F@libero.it |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hello to all ...
I'm trying to install a backup system for my Postgresql 8.1.1 (on windows xp) using 3 wal files.
So i change these parameters in postgresql.conf
checkpoint_segments = 3
archive_command = 'copy "%p" "D:/PostgreSQL/backup/%f"'
I stop the database service and then restart it ...
Before restart i have 1 wal now i have 1 wal file ...
I start to generate data to populate wal files and postgres start to generate new wal files and copy them to the destination folder.
The problem is that files number don't stop to increase, now i have 10 wal files in pg_xlog and 9 files in backup folder ...
why the backup files don't be deleted ?
thanks a lot in advance ...
Fabio
From | Date | Subject | |
---|---|---|---|
Next Message | Devrim GUNDUZ | 2005-12-14 11:19:29 | Re: PG 8.1.1 rhel-as-4 rpms missing - Now not initdb issues |
Previous Message | Praveen Kumar (TUV) | 2005-12-14 09:23:46 | Please guide me. |