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