From owner-freebsd-questions@FreeBSD.ORG  Thu Jan 10 22:11:00 2008
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
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 8662316A46B
	for <freebsd-questions@freebsd.org>;
	Thu, 10 Jan 2008 22:11:00 +0000 (UTC)
	(envelope-from Albert.Shih@obspm.fr)
Received: from mesiob.obspm.fr (mesiob.obspm.fr [145.238.2.2])
	by mx1.freebsd.org (Postfix) with ESMTP id 0C00A13C4D3
	for <freebsd-questions@freebsd.org>;
	Thu, 10 Jan 2008 22:10:59 +0000 (UTC)
	(envelope-from Albert.Shih@obspm.fr)
Received: from localhost (pcjas.obspm.fr [145.238.184.233])
	by mesiob.obspm.fr (8.13.4/8.13.4/SIO Observatoire de Paris) with ESMTP
	id m0AMAwYM020128
	for <freebsd-questions@freebsd.org>; Thu, 10 Jan 2008 23:10:58 +0100
Date: Thu, 10 Jan 2008 23:10:58 +0100
From: Albert Shih <Albert.Shih@obspm.fr>
To: freebsd-questions@freebsd.org
Message-ID: <20080110221058.GA81742@pcjas.obspm.fr>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
User-Agent: Mutt/1.5.17 (2007-11-01)
X-Greylist: Sender IP whitelisted, not delayed by milter-greylist-2.0.2
	(mesiob.obspm.fr [145.238.2.2]);
	Thu, 10 Jan 2008 23:10:58 +0100 (CET)
X-Virus-Scanned: ClamAV version 0.92,
	clamav-milter version 0.92 on mesiob.obspm.fr
X-Virus-Status: Clean
Subject: How backup huge pgsql ?
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
Reply-To: Albert.Shih@obspm.fr
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Thu, 10 Jan 2008 22:11:00 -0000

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 ? 

Regards.

--
Albert SHIH
Observatoire de Paris Meudon
SIO batiment 15
Heure local/Local time:
Jeu 10 jan 2008 23:05:00 CET