Re: pg_dump vs pg_basebackup

Поиск
Список
Период
Сортировка
От Joshua D. Drake
Тема Re: pg_dump vs pg_basebackup
Дата
Msg-id 53319F4F.3000005@commandprompt.com
обсуждение исходный текст
Ответ на Re: pg_dump vs pg_basebackup  (Ilya Kosmodemiansky <ilya.kosmodemiansky@postgresql-consulting.com>)
Ответы Re: pg_dump vs pg_basebackup  (Ilya Kosmodemiansky <ilya.kosmodemiansky@postgresql-consulting.com>)
Re: pg_dump vs pg_basebackup  (Claudio Freire <klaussfreire@gmail.com>)
Список pgsql-performance
On 03/25/2014 08:18 AM, Ilya Kosmodemiansky wrote:
>
> Joshua,
>
> that is really good point: an alternative is to use pg_basebackup
> through ssh tunnel with compression, but rsync is much simpler.

Or rsync over ssh. 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.

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.


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

Предыдущее
От: Magnus Hagander
Дата:
Сообщение: Re: pg_dump vs pg_basebackup
Следующее
От: Ilya Kosmodemiansky
Дата:
Сообщение: Re: pg_dump vs pg_basebackup