Thread

1. backup and archive postgresql data older than 6 months

   Kaushal Shriyan <kaushalshriyan@gmail.com> — 2015-08-26T10:46:53Z

   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
   

2. Re: backup and archive postgresql data older than 6 months

   Ian Barwick <ian@2ndquadrant.com> — 2015-08-26T11:09:03Z

   On 15/08/26 19:46, 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.
   
   Have you looked at Barman ( http://www.pgbarman.org/ )?
   
   
   Regards
   
   Ian Barwick
   
   -- 
    Ian Barwick                   http://www.2ndQuadrant.com/
    PostgreSQL Development, 24x7 Support, RemoteDBA, Training & Services
   
   
   

3. Re: backup and archive postgresql data older than 6 months

   Vincent Veyron <vv.lists@wanadoo.fr> — 2015-08-26T12:55:51Z

   On Wed, 26 Aug 2015 10:46:53 +0000
   Kaushal Shriyan <kaushalshriyan@gmail.com> 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.
   
   What system are you on?
   
   On linux, you can use log_rotate to rotate your backups; just add a file to /etc/logrotate.d. Here is what I use to keep a weekly backup over one year:
   
   /var/backups/marica/marica.gz {
   	weekly
   	missingok
   	rotate 52
   	notifempty
   }
   
   And here is a naive bash script to send a dump file to a remote server; it's launched by cron:
   
   http://pastebin.com/Xg4wXdjy
   
   
   
   -- 
   					Salutations, Vincent Veyron 
   
   https://legalcase.libremen.com/ 
   Legal case, contract and insurance claim management software
   
   
   

4. Re: backup and archive postgresql data older than 6 months

   Adrian Klaver <adrian.klaver@aklaver.com> — 2015-08-26T13:14:00Z

   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@aklaver.com