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. # #================================================== [EMAIL PROTECTED] #
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
