Re: 7.4 hot backup capabilities?

From: Jan Wieck <JanWieck(at)Yahoo(dot)com>
To: Austin Gonyou <austin(at)coremetrics(dot)com>
Cc: Shridhar Daithankar <shridhar_daithankar(at)myrealbox(dot)com>, PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: 7.4 hot backup capabilities?
Date: 2003-11-12 14:05:29
Message-ID: 3FB23E29.3040804@Yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Austin Gonyou wrote:

> On Wed, 2003-11-12 at 01:00, Shridhar Daithankar wrote:
>> Austin Gonyou wrote:
>>
>> > What facilities are/will be available for hot(online) backups with the
>> > 7.4 release? PITR, something else? TIA.
>>
>> pg_dump?
>>
>> Did you mean hot failover or hot backup? Postgresql does hot backup for a long time.
>
> I was referring primarly to hot backup. We're migrating from Oracle to
> pgsql, and we wanted to know more about this. From our current
> understanding, pgsql's hot backup is more of an export, than say, a hot
> backup with redo-logs type mode.(i.e. oracle rman). Is there a similar
> utility? I didn't think that pg_dump did that functionality as an actual
> "backup". i.e. keeps track of block changes while IO is going on and
> ensures stuff in process gets backed up as well.

You might want to read section 1.5 of my Slony-I proposal

http://developer.postgresql.org/~wieck/slony1.html

It might take 2-3 months until we have the first BETA. I hope that will
fit your migration projects time table.

Jan

--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-11-12 15:23:54 Re: rpm support for 7.4 and beyond
Previous Message Patrick Welche 2003-11-12 13:59:29 Re: NetBSD/acorn32