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
--C7zPtVaVf+AK4Oqc Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Thu, Jan 10, 2008 at 11:10:58PM +0100, Albert Shih wrote: > Hi all >=20 > I want to known how can I make backup of huge postgresql database (huge > mean ~ 2To).=20 >=20 > I can stop the access of the database during N>>1 hours. >=20 > Any idea about this ?=20 Take a look at the PostgreSQL web site - they have a section in the=20 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=20 http://www.postgresql.org/docs/manuals/)=20 Dan --=20 Daniel Bye _ ASCII ribbon campaign ( ) - against HTML, vCards and X - proprietary attachments in e-mail / \ --C7zPtVaVf+AK4Oqc Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.4 (FreeBSD) iD8DBQFHh1ZBixf5fBYiFmoRAgV2AJ476ku3B/0DJeFUYKsUHaGbhtQyOwCguP4F wkTd6a19G97ao7lLNMU7vD4= =jSkG -----END PGP SIGNATURE----- --C7zPtVaVf+AK4Oqc--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20080111114257.GA1180>