Re: pg_dump vs pg_basebackup

Поиск
Список
Период
Сортировка
От Ilya Kosmodemiansky
Тема Re: pg_dump vs pg_basebackup
Дата
Msg-id CAG95seWXZo9O_AJs_cNyiyw8obN7guaeRutzDCN1oaiGTReP6w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pg_dump vs pg_basebackup  ("Joshua D. Drake" <jd@commandprompt.com>)
Ответы Re: pg_dump vs pg_basebackup  ("Graeme B. Bell" <grb@skogoglandskap.no>)
Список pgsql-performance
Joshua,

On Tue, Mar 25, 2014 at 4:22 PM, Joshua D. Drake <jd@commandprompt.com> wrote:
The advantage is that you can create backups that don't
> have to be restored, just started. You can also use the differential
> portions of rsync to do it multiple times a day without much issue.

Are you sure, that it is a nice idea on a database with heavy write workload?

And also Im not sure, that differential backups using rsync will be
recoverable, if you have actually meant that.

>
>
> JD
>
> --
> Command Prompt, Inc. - http://www.commandprompt.com/  509-416-6579
> PostgreSQL Support, Training, Professional Services and Development
> High Availability, Oracle Conversion, Postgres-XC, @cmdpromptinc
> Political Correctness is for cowards.



--
Ilya Kosmodemiansky,

PostgreSQL-Consulting.com
tel. +14084142500
cell. +4915144336040
ik@postgresql-consulting.com


В списке pgsql-performance по дате отправления:

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: pg_dump vs pg_basebackup
Следующее
От: Ilya Kosmodemiansky
Дата:
Сообщение: Re: pg_dump vs pg_basebackup