backup and archive postgresql data older than 6 months

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general