pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Script for hotbackup
3+ messages / 2 participants
[nested] [flat]

* Script for hotbackup
@ 2006-11-08 07:46  Moiz Kothari <moizpostgres@gmail.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Moiz Kothari @ 2006-11-08 07:46 UTC (permalink / raw)
  To: pgsql-admin

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.

Regards,
Moiz Kothari

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Script for hotbackup
@ 2006-11-08 07:51  Jeff Frost <jeff@frostconsultingllc.com>
  parent: Moiz Kothari <moizpostgres@gmail.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Jeff Frost @ 2006-11-08 07:51 UTC (permalink / raw)
  To: Moiz Kothari <moizpostgres@gmail.com>; +Cc: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Script for hotbackup
@ 2006-11-08 10:46  Moiz Kothari <moizpostgres@gmail.com>
  parent: Jeff Frost <jeff@frostconsultingllc.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Moiz Kothari @ 2006-11-08 10:46 UTC (permalink / raw)
  To: Jeff Frost <jeff@frostconsultingllc.com>; +Cc: pgsql-admin

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
>

^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2006-11-08 10:46 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-11-08 07:46 Script for hotbackup Moiz Kothari <moizpostgres@gmail.com>
2006-11-08 07:51 ` Jeff Frost <jeff@frostconsultingllc.com>
2006-11-08 10:46   ` Moiz Kothari <moizpostgres@gmail.com>

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