backup and archive postgresql data older than 6 months

Поиск
Список
Период
Сортировка
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