Thanks everybody for your valuable comments. I can specify how many versions of the files should be kept on Tivoli.
The database will regularly get new data and there is a continuous process of data cleaning. It is a database mainly for research purposes and a few researchers are using it. I will explore the options mentioned. After the first read it looks like continuing pg_dump is not a bad idea - maybe with some optimization (like using diff's). Regards Johann On 9 April 2013 12:05, Eduardo Morras <emorr...@yahoo.es> wrote: > On Mon, 8 Apr 2013 10:40:16 -0500 > Shaun Thomas <stho...@optionshouse.com> wrote: > > > > > Anyone else? > > > > If his db has low inserts/updates/deletes he can use diff between pg_dumps > (with default -Fp) before compressing. > > --- --- > Eduardo Morras <emorr...@yahoo.es> > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Because experiencing your loyal love is better than life itself, my lips will praise you. (Psalm 63:3)