Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: How to increace nightly backup speed
- From: "Joshua D. Drake" <jd(at)commandprompt(dot)com>
- To: Jeff Davis <pgsql(at)j-davis(dot)com>
- Cc: Andrus <eetasoft(at)online(dot)ee>, pgsql-general(at)postgresql(dot)org
- Subject: Re: How to increace nightly backup speed
- Date: Mon, 27 Nov 2006 10:15:19 -0800
- Message-id: <1164651319(dot)16182(dot)29(dot)camel(at)localhost(dot)localdomain>
> > > > 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
- References:
- How to increace nightly backup speed
- From: Andrus
- Re: How to increace nightly backup speed
- From: Jeff Davis
- How to increace nightly backup speed
- Prev by Date: SSL error: decryption failed or bad record mac
- Next by Date: PostgreSQL doesn't accept connections when Windows Server is rebooted
- Previous by thread: Re: How to increace nightly backup speed
- Next by thread: Re: How to increace nightly backup speed
- Indexes: