Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 58F3A9FB258 for ; Wed, 8 Nov 2006 06:46:52 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 51962-06 for ; Wed, 8 Nov 2006 06:46:48 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.175]) by postgresql.org (Postfix) with ESMTP id 432AF9FB24A for ; Wed, 8 Nov 2006 06:46:47 -0400 (AST) Received: by ug-out-1314.google.com with SMTP id k3so1260642ugf for ; Wed, 08 Nov 2006 02:46:45 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=ljMl+QgZ8s2t1nosMTbpbNJbEF7CwtoNJ6+z3/RQAwQ8ftGRjjc5+JwBqtuCwX4vk8sHQQAz4IKq334yncsKkIFJVAvOze46bHnfjCSTsmHlmdN50jzOdXnpDyaTB53k60/PlbdONquUwf7pb4Ivz9D2ff2rSC+WzqEfgaOwUJs= Received: by 10.67.121.15 with SMTP id y15mr10607639ugm.1162982804756; Wed, 08 Nov 2006 02:46:44 -0800 (PST) Received: by 10.67.26.19 with HTTP; Wed, 8 Nov 2006 02:46:44 -0800 (PST) Message-ID: <82e1a9bd0611080246k66ec7920j487d87590f974@mail.gmail.com> Date: Wed, 8 Nov 2006 16:16:44 +0530 From: "Moiz Kothari" To: "Jeff Frost" Subject: Re: Script for hotbackup Cc: pgsql-admin@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_19809_20678080.1162982804491" References: <82e1a9bd0611072346v41313ddbn3f96f1422253eee8@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/75 X-Sequence-Number: 23602 ------=_Part_19809_20678080.1162982804491 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi Jeff, This is what i really wanted, thanks for replying back so quick... I wanted to automate the PITR backup, so that we have DB backup for a PITR. Thanks a tons. Regards, Moiz Kothari On 11/8/06, Jeff Frost wrote: > > On Wed, 8 Nov 2006, Moiz Kothari wrote: > > > Guys, > > > > I think postgres 8.1 onwards gives hot backup facility, i was searching > on > > net for an automated script to do that for me. But i cannot find > any. Has > > anyone written a script to do something like that automated on linux. > > > > If anyone has written and tested, i would appricate if you can share it > with > > me. > > This depends what you mean by hot backup. The pg_dump utility can create > a > consistent database dump with no need to stop the postgresql > service. But, > perhaps you mean the Point in Time Recovery backup method? If so, you > might > look at the pgpitrha project. We haven't released any tarballs yet, but > you > could pull some useful scripts out of CVS. > http://pgfoundry.org/projects/pgpitrha > > If this doesn't get you on the right track, perhaps you can define what > you > mean by hot backup more precisely. > > -- > Jeff Frost, Owner > Frost Consulting, LLC http://www.frostconsultingllc.com/ > Phone: 650-780-7908 FAX: 650-649-1954 > ------=_Part_19809_20678080.1162982804491 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi Jeff,

This is what i really wanted, thanks for replying back so quick... I wanted to automate the PITR backup, so that we have DB backup for a PITR.

Thanks a tons.

Regards,
Moiz Kothari

On 11/8/06, Jeff Frost <jeff@frostconsultingllc.com> wrote:
On Wed, 8 Nov 2006, Moiz Kothari wrote:

> Guys,
>
> I think postgres 8.1 onwards gives hot backup facility, i was searching on
> net for an automated script to do that for me. But i cannot find any.  Has
> anyone written a script to do something like that automated on linux.
>
> If anyone has written and tested, i would appricate if you can share it with
> me.

This depends what you mean by hot backup.  The pg_dump utility can create a
consistent database dump with no need to stop the postgresql service.  But,
perhaps you mean the Point in Time Recovery backup method?  If so, you might
look at the pgpitrha project.  We haven't released any tarballs yet, but you
could pull some useful scripts out of CVS.
http://pgfoundry.org/projects/pgpitrha

If this doesn't get you on the right track, perhaps you can define what you
mean by hot backup more precisely.

--
Jeff Frost, Owner       <jeff@frostconsultingllc.com>
Frost Consulting, LLC   http://www.frostconsultingllc.com/
Phone: 650-780-7908     FAX: 650-649-1954

------=_Part_19809_20678080.1162982804491--