X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 4C266D1B18F for ; Mon, 31 May 2004 06:09:35 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 18163-05 for ; Mon, 31 May 2004 06:09:36 -0300 (ADT) Received: from wolff.to (wolff.to [66.93.249.74]) by svr1.postgresql.org (Postfix) with SMTP id C17EED1B181 for ; Mon, 31 May 2004 06:09:32 -0300 (ADT) Received: (qmail 10956 invoked by uid 500); 31 May 2004 09:15:03 -0000 Date: Mon, 31 May 2004 04:15:03 -0500 From: Bruno Wolff III To: Krishna R Palati Cc: pgsql-admin@postgresql.org Subject: Re: Hot backup Message-ID: <20040531091503.GA10575@wolff.to> Mail-Followup-To: Krishna R Palati , pgsql-admin@postgresql.org References: <200405261450.i4QEoOXg060290@mx1.hedgehoghosting.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <200405261450.i4QEoOXg060290@mx1.hedgehoghosting.net> User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200405/336 X-Sequence-Number: 13652 On Wed, May 26, 2004 at 10:50:21 -0400, Krishna R Palati wrote: > > I read online that Postgres 7.4.1 has the capability to do hotbackups > (equivalent to Hotbackups on Oracle). But am not able to find any > documentation which will help me set up one. Can you please point me to a > resource that I can use to set up hotbackups for Postgres 7.4.1 ? pg_dump and pg_dumpall provide consistant dumps of the database.