backup and wal files

Поиск
Список
Период
Сортировка
От f\.guidi\@libero\.it
Тема backup and wal files
Дата
Msg-id IRHFO2$750AAB7343D67ACD2DBE3C72F501E54F@libero.it
обсуждение исходный текст
Ответы Re: backup and wal files  ("Jim C. Nasby" <jnasby@pervasive.com>)
Список 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
destinationfolder. 

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


В списке pgsql-admin по дате отправления:

Предыдущее
От: "Magnus Hagander"
Дата:
Сообщение: Re: reg: Errors on Windows application(urgent)
Следующее
От: Devrim GUNDUZ
Дата:
Сообщение: Re: PG 8.1.1 rhel-as-4 rpms missing - Now not initdb issues