From owner-freebsd-questions@FreeBSD.ORG Fri Jan 11 11:43:01 2008 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id B122916A418 for ; Fri, 11 Jan 2008 11:43:01 +0000 (UTC) (envelope-from freebsd-questions@slightlystrange.org) Received: from catflap.slightlystrange.org (cpc5-cmbg1-0-0-cust497.cmbg.cable.ntl.com [86.6.1.242]) by mx1.freebsd.org (Postfix) with ESMTP id 641E813C448 for ; Fri, 11 Jan 2008 11:43:01 +0000 (UTC) (envelope-from freebsd-questions@slightlystrange.org) Received: by catflap.slightlystrange.org (Postfix, from userid 106) id 288C16196; Fri, 11 Jan 2008 11:43:00 +0000 (GMT) Received: from brick.slightlystrange.org (brick.slightlystrange.org [10.1.3.48]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by catflap.slightlystrange.org (Postfix) with ESMTP id 8339F60E8 for ; Fri, 11 Jan 2008 11:42:59 +0000 (GMT) Received: (from danielby@localhost) by brick.slightlystrange.org (8.14.2/8.13.4/Submit) id m0BBgvi5001322 for freebsd-questions@freebsd.org; Fri, 11 Jan 2008 11:42:57 GMT (envelope-from freebsd-questions@slightlystrange.org) Date: Fri, 11 Jan 2008 11:42:57 +0000 From: Daniel Bye To: freebsd-questions@freebsd.org Message-ID: <20080111114257.GA1180@brick.slightlystrange.org> Mail-Followup-To: freebsd-questions@freebsd.org References: <20080110221058.GA81742@pcjas.obspm.fr> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="C7zPtVaVf+AK4Oqc" Content-Disposition: inline In-Reply-To: <20080110221058.GA81742@pcjas.obspm.fr> User-Agent: Mutt/1.4.2.3i X-PGP-Fingerprint: D349 B109 0EB8 2554 4D75 B79A 8B17 F97C 1622 166A Subject: Re: How backup huge pgsql ? X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: Daniel Bye List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 11 Jan 2008 11:43:01 -0000 --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--