pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / 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