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

Attachment: pgpFFxdXeXc0q.pgp
Description: PGP signature

Reply via email to