Deleting old WAL-files
От | Gustav Karlsson |
---|---|
Тема | Deleting old WAL-files |
Дата | |
Msg-id | 5FB35597-0F52-4832-973D-908F5B01BE9B@bekk.no обсуждение исходный текст |
Ответы |
Re: Deleting old WAL-files
Re: Deleting old WAL-files Re: Deleting old WAL-files Proper way to restore from a basebackup without the WAL-files? |
Список | pgsql-admin |
Hi, I am looking for a good method of determining what WAL-segments can be deleted from our backup-archive. We are using Postgresql 9.3 and do nightly basebackups along with archiving of WAL-segments. We would like to prevent our backup-archive from growing forever, and thus delete basebackups and WAL-segments older thansay 1 year. Is there a good way of finding the oldest WAL-segment needed for a given basebackup? (If not, what is the typical methodfor deleting old WAL-segments?) (We are aware that Barman is offering this functionality, and might migrate to using it, but would still like to know themethod used) Regards, Gustav Karlsson
В списке pgsql-admin по дате отправления: