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@Yahoo.com #