Re: Backup advice
| От | Johann Spies |
|---|---|
| Тема | Re: Backup advice |
| Дата | |
| Msg-id | CAGZ55DTpdsJRDF73XDwJ801pko02USoOi3e3x-14PmR4KmBXPA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Backup advice (Eduardo Morras <emorrasg@yahoo.es>) |
| Ответы |
Re: Backup advice
|
| Список | pgsql-general |
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).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.
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 по дате отправления: