Re: How to increace nightly backup speed

Поиск
Список
Период
Сортировка
От Joshua D. Drake
Тема Re: How to increace nightly backup speed
Дата
Msg-id 1164651319.16182.29.camel@localhost.localdomain
обсуждение исходный текст
Ответ на Re: How to increace nightly backup speed  (Jeff Davis <pgsql@j-davis.com>)
Список pgsql-general
> >
>
> You might try using online backups. By following the steps in this
> document:
>
> http://www.postgresql.org/docs/8.1/static/backup-online.html
>
> you can back up the data at the speed of your filesystem. There's no way
> to make it faster than that.

Note however that you will want to apply the backups to the copied
version of the postgresql every night. Otherwise you are likely looking
at a very long restore process should you need to bring it up.

Joshua D. Drake


>
> Hope this helps,
>      Jeff Davis
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>
--

      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
             http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate




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

Предыдущее
От: "Claudio Rossi"
Дата:
Сообщение: SSL error: decryption failed or bad record mac
Следующее
От: George Weaver
Дата:
Сообщение: PostgreSQL doesn't accept connections when Windows Server is rebooted