On 08/26/2015 03:46 AM, Kaushal Shriyan wrote:
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.
Not entirely sure what you want here?:
1) Do you want to keep a set of backups that end no less then 6 months ago
or
2) Do you want the actual data in the server to be no more then 6 months
old with older data pulled out and archived.
If 2)
A) How do you propose determining the age of a record ?
B) How do you deal with FK relationships and missing data?
Any help will be highly appreciable.
Regards,
Kaushal
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
