restore from xlog

From: CH <share-postgres(at)think42(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: restore from xlog
Date: 2004-05-19 12:31:54
Message-ID: 20040519143154.B28610@p15097255.pureserver.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All,

even with PITR not in place yet, how far is it possible to use the xlog to
restore a database (beyond redo-after-crash)? Suppose I lose my data
partition, but have an archive of my xlog and clog, and occasional pg_dumps,
it probably won't be as simple as restoring from the dump, stopping pg,
copying in the archived xlog and clog, and restarting the pg (to get an
effect similar to playing back the redo logs in oracle) ...

I am not sure whether the whole question makes sense, so please tell me if
it doesn't. I am trying to get a backup that is more fine-grained than
just snapshots. (Or, with the MVCC model and database sizes not more than a
GBor two, are pg_dumps so cheap that I can do them much more frequently than
a full backup in oracle?)

My search for backup solutions on the web gave me either wrappers around
pg_dump, or something in the direction of replication and mirroring, many of
which seemed out-of-date ... can anyone point me to the "preferred" backup
solutions out there?

Thank you for your time (in light of my slightly confused questions),
Colin

Browse pgsql-general by date

  From Date Subject
Next Message Jerry Sievers 2004-05-19 12:32:06 pg_temp_N temp schema buildup
Previous Message Peter Haworth 2004-05-19 10:02:50 Is using cross-version pg_autovacuum possible/safe?