X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 66C489DC998 for ; Wed, 14 Dec 2005 06:06:14 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 26476-08 for ; Wed, 14 Dec 2005 06:06:14 -0400 (AST) X-Greylist: delayed 00:08:31.077854 by SQLgrey- Received: from smtp3.libero.it (smtp3.libero.it [193.70.192.127]) by postgresql.org (Postfix) with ESMTP id C5EC39DC997 for ; Wed, 14 Dec 2005 06:06:08 -0400 (AST) Received: from localhost (172.16.1.83) by smtp3.libero.it (7.0.027-DD01) id 439D9110002FFFD4 for pgsql-admin@postgresql.org; Wed, 14 Dec 2005 10:57:38 +0100 Received: from smtp1.libero.it ([172.16.1.97]) by localhost (asav4.libero.it [193.70.192.153]) (amavisd-new, port 10024) with ESMTP id 02760-01-9 for ; Wed, 14 Dec 2005 10:57:38 +0100 (CET) Received: from libero.it (172.16.1.109) by smtp1.libero.it (7.0.027-DD01) id 431C3A42010D7DB1 for pgsql-admin@postgresql.org; Wed, 14 Dec 2005 10:57:38 +0100 Date: Wed, 14 Dec 2005 10:57:38 +0100 Message-Id: Subject: backup and wal files MIME-Version: 1.0 X-Sensitivity: 3 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable From: "f\.guidi\@libero\.it" To: "pgsql-admin" X-XaM3-API-Version: 4.3 (R1) (B3pl11) X-SenderIP: 194.243.137.76 X-Scanned: with antispam and antivirus automated system at libero.it X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.919 required=5 tests=[DNS_FROM_RFC_ABUSE=0.479, DNS_FROM_RFC_POST=1.44] X-Spam-Score: 1.919 X-Spam-Level: * X-Archive-Number: 200512/117 X-Sequence-Number: 19837 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 =3D 3 archive_command =3D '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 gene= rate 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 wa= l files in pg_xlog and 9 files in backup folder ... why the backup files don't be deleted ? thanks a lot in advance ... Fabio