X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 0057F3A6184 for ; Tue, 7 Dec 2004 11:31:32 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 30929-07 for ; Tue, 7 Dec 2004 11:31:19 +0000 (GMT) Received: from rproxy.gmail.com (rproxy.gmail.com [64.233.170.199]) by svr1.postgresql.org (Postfix) with ESMTP id 394E13A5645 for ; Tue, 7 Dec 2004 11:31:20 +0000 (GMT) Received: by rproxy.gmail.com with SMTP id z35so20260rne for ; Tue, 07 Dec 2004 03:31:19 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=LlYFqNyYFl+hYuEThepWXnA1hW733LZn9cIc5ICUc3Zqfr5BR+LjVp13Eqf6WqxhXxx5/Wz/vJwM/pR+qeGvodRMbP5/w+d/onMfxKtEMCipNw3GhEQrJqlt4JLf0yvfqEU0Dx3iByfVJHVPPoUPh8ygUD+evHaYReGta63TPMw= Received: by 10.38.15.9 with SMTP id 9mr39450rno; Tue, 07 Dec 2004 03:31:19 -0800 (PST) Received: by 10.38.97.24 with HTTP; Tue, 7 Dec 2004 03:31:19 -0800 (PST) Message-ID: <674d1f8a04120703316af85b8c@mail.gmail.com> Date: Tue, 7 Dec 2004 17:01:19 +0530 From: Gourish Singbal Reply-To: Gourish Singbal To: Christopher Browne Subject: Re: Need Help in Taking Backups Cc: pgsql-admin@postgresql.org In-Reply-To: <31kp6gF3ad57bU2@individual.net> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit References: <674d1f8a041206062862d3480a@mail.gmail.com> <31kp6gF3ad57bU2@individual.net> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.265 tagged_above=0 required=5 tests=AWL, INFO_TLD, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200412/55 X-Sequence-Number: 15641 Thanks, i think Slony-I might be an answer to my questions. But need to explore Slony-I before saying anything. Has Anybody found any dificulties in implementing hotback, using Slony-I. Thoughts would be of great help. regards Gourish. On 7 Dec 2004 04:17:21 GMT, Christopher Browne wrote: > Well, you can take a pg_dump to get the state of the system at a point > in time. That's very easy. > > > > But you really need to specify your 'disaster modelling' and recovery > requirements in _much_ greater detail. It may be that in order to > keep recovery time down, you'll need to use a replication system such > as Slony-I to give you a "hot backup" that's sitting just a few > transactions behind. > -- > let name="cbbrowne" and tld="gmail.com" in name ^ "@" ^ tld;; > http://linuxfinances.info/info/postgresql.html > "We defeated the enemy with teamwork and the hammer of not bickering." > -- The Shoveller, Mystery Men > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly > -- Best, Gourish Singbal