On Thu, Jan 10, 2008 at 11:10:58PM +0100, Albert Shih wrote: > Hi all > > I want to known how can I make backup of huge postgresql database (huge > mean ~ 2To). > > I can stop the access of the database during N>>1 hours. > > Any idea about this ?
Take a look at the PostgreSQL web site - they have a section in the docs dedicated to this subject, detailing several different strategies. I'm sure one of them will fit! http://www.postgresql.org/docs/8.2/static/backup.html (If you're running a diffrent version of PostgreSQL, check out the relevant section of the docs - accessible from http://www.postgresql.org/docs/manuals/) Dan -- Daniel Bye _ ASCII ribbon campaign ( ) - against HTML, vCards and X - proprietary attachments in e-mail / \
Description: PGP signature