Date: Fri, 11 Jan 2008 11:42:57 +0000 From: Daniel Bye <freebsd-questions@slightlystrange.org> To: freebsd-questions@freebsd.org Subject: Re: How backup huge pgsql ? Message-ID: <20080111114257.GA1180@brick.slightlystrange.org> In-Reply-To: <20080110221058.GA81742@pcjas.obspm.fr> References: <20080110221058.GA81742@pcjas.obspm.fr>
next in thread | previous in thread | raw e-mail | index | archive | help
[-- Attachment #1 --] 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 #2 --] -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.4 (FreeBSD) iD8DBQFHh1ZBixf5fBYiFmoRAgV2AJ476ku3B/0DJeFUYKsUHaGbhtQyOwCguP4F wkTd6a19G97ao7lLNMU7vD4= =jSkG -----END PGP SIGNATURE-----
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20080111114257.GA1180>