Search Postgresql Archives

Re: How to increace nightly backup speed

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux