How backup huge pgsql ?

[Daniel Bye]

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 / \
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 187 bytes
Desc: not available
Url : http://lists.freebsd.org/pipermail/freebsd-questions/attachments/20080111/3016b447/attachment.pgp