From owner-freebsd-questions@FreeBSD.ORG Mon Oct 24 17:49:47 2005 Return-Path: X-Original-To: freebsd-questions@freebsd.org Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 03EF416A41F for ; Mon, 24 Oct 2005 17:49:47 +0000 (GMT) (envelope-from bob@bobleeit.net) Received: from fed1rmmtao12.cox.net (fed1rmmtao12.cox.net [68.230.241.27]) by mx1.FreeBSD.org (Postfix) with ESMTP id 9D37A43D49 for ; Mon, 24 Oct 2005 17:49:46 +0000 (GMT) (envelope-from bob@bobleeit.net) Received: from [24.251.222.159] by fed1rmmtao12.cox.net (InterMail vM.6.01.05.02 201-2131-123-102-20050715) with SMTP id <20051024174907.SFXX2059.fed1rmmtao12.cox.net@[24.251.222.159]> for ; Mon, 24 Oct 2005 13:49:07 -0400 Received: by _HOSTNAME_ (sSMTP sendmail emulation); Mon, 24 Oct 2005 10:50:44 -0700 From: "Bob Lee" Date: Mon, 24 Oct 2005 10:50:44 -0700 To: freebsd-questions@freebsd.org Message-ID: <20051024175044.GA8036@mach.cnsisp.com> References: <810a540e0510241002l56e9e0d1ra4c4f949da4a8fb9@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <810a540e0510241002l56e9e0d1ra4c4f949da4a8fb9@mail.gmail.com> User-Agent: Mutt/1.5.11 Subject: Re: Backing up postgresql data X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: Bob Lee List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 24 Oct 2005 17:49:47 -0000 Hello Pat, Just advice from another user -- I always used the dump facility and have restored the data successfully using this method. Thge only glitch that I can ever recall was self-inflicted as I upgraded the DB and then the data couldn't be directly restored. That was a while ago and my memory may not be perfect on that detail. Bob Lee Quoting Pat Maddox : > I've got postgresql 8 running on my system, and want to do nightly > backups of the database. I took a look at the docs, and there are a > few methods of doing backups - pg_dump, file system level, and using > WAL. I just want to be able to rsync my data every night, maybe every > few hours, so that I can recover it if there are any problems...so > what's the best way to do this. Are there any scripts or utilities > available to make my life easy? > > Thanks, > Pat > _______________________________________________ > freebsd-questions@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to "freebsd-questions-unsubscribe@freebsd.org" -- ********* I prefer mail in plain text format ********** PGP/GnuPG: D3EE2269