backup and archive postgresql data older than 6 months

Поиск
Список
Период
Сортировка
От Kaushal Shriyan
Тема backup and archive postgresql data older than 6 months
Дата
Msg-id CAD7Ssm-6BjLp8g-dEJ3n-263G=dgk=P2DgT_kyYc9g5Th6Rctg@mail.gmail.com
обсуждение исходный текст
Ответы Re: backup and archive postgresql data older than 6 months  (Ian Barwick <ian@2ndquadrant.com>)
Re: backup and archive postgresql data older than 6 months  (Vincent Veyron <vv.lists@wanadoo.fr>)
Re: backup and archive postgresql data older than 6 months  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
Hi,

Are there scripts which takes backup of postgresql database and archive data older than 6 months and push it to a remote server using scp or rsync method and purge/clean the local data on the hard disk at the same time meaning at any given time we have only six months of postgresql data on the postgresql database server.

Any help will be highly appreciable.

Regards,

Kaushal

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

Предыдущее
От: Allan Kamau
Дата:
Сообщение: Re: PostgreSQL Developer Best Practices
Следующее
От: Ian Barwick
Дата:
Сообщение: Re: backup and archive postgresql data older than 6 months