pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Moiz Kothari <moizpostgres@gmail.com>
To: Jeff Frost <jeff@frostconsultingllc.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Script for hotbackup
Date: Wed, 8 Nov 2006 16:16:44 +0530
Message-ID: <82e1a9bd0611080246k66ec7920j487d87590f974@mail.gmail.com> (raw)
In-Reply-To: <Pine.LNX.4.64.0611072347460.23695@discord.home.frostconsultingllc.com>
References: <82e1a9bd0611072346v41313ddbn3f96f1422253eee8@mail.gmail.com>
	<Pine.LNX.4.64.0611072347460.23695@discord.home.frostconsultingllc.com>

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
>

view thread (3+ messages)

Message-ID: <82e1a9bd0611080246k66ec7920j487d87590f974@mail.gmail.com>
Permalink:  ../82e1a9bd0611080246k66ec7920j487d87590f974@mail.gmail.com/
Also on:    postgresql.org/message-id/82e1a9bd0611080246k66ec7920j487d87590f974@mail.gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: moizpostgres@gmail.com, jeff@frostconsultingllc.com
  Subject: Re: Script for hotbackup
  In-Reply-To: <82e1a9bd0611080246k66ec7920j487d87590f974@mail.gmail.com>
  References: <82e1a9bd0611072346v41313ddbn3f96f1422253eee8@mail.gmail.com> <Pine.LNX.4.64.0611072347460.23695@discord.home.frostconsultingllc.com> <82e1a9bd0611080246k66ec7920j487d87590f974@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox