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).

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 по дате отправления:

Предыдущее
От: Albe Laurenz
Дата:
Сообщение: Re: What is pg backend using memory for?
Следующее
От: Gabriele Bartolini
Дата:
Сообщение: Re: Backup advice