|
Home > Archive > PostgreSQL Administration > November 2006 > Script for hotbackup
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Script for hotbackup
|
|
| Moiz Kothari 2006-11-08, 5:44 am |
| 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
| |
| Jeff Frost 2006-11-08, 5:44 am |
| 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@frostconsulting
llc.com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
| |
| Moiz Kothari 2006-11-08, 5:44 am |
| 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@frostconsulting
llc.com> wrote:
>
> On Wed, 8 Nov 2006, Moiz Kothari wrote:
>
> on
> any. Has
> with
>
> 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@frostconsulting
llc.com>
> Frost Consulting, LLC http://www.frostconsultingllc.com/
> Phone: 650-780-7908 FAX: 650-649-1954
>
|
|
|
|
|