Postgres Pro
Downloads
Home   >   mailing lists

Re: Backup advice - Mailing list pgsql-general

From Johann Spies
Subject Re: Backup advice
Date
Msg-id CAGZ55DTpdsJRDF73XDwJ801pko02USoOi3e3x-14PmR4KmBXPA@mail.gmail.com
Whole thread Raw
In response to Re: Backup advice  (Eduardo Morras <emorrasg@yahoo.es>)
Responses Re: Backup advice
List pgsql-general
Tree view
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 <emorrasg@yahoo.es> wrote:
On Mon, 8 Apr 2013 10:40:16 -0500
Shaun Thomas <sthomas@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 <emorrasg@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)

pgsql-general by date:

Previous
From: Albe Laurenz
Date:
Subject: Re: What is pg backend using memory for?
Next
From: Gabriele Bartolini
Date:
Subject: Re: Backup advice