Jonah H. Harris wrote:
On Mon, Apr 7, 2008 at 2:58 PM, Heikki Linnakangas
<[EMAIL PROTECTED]> wrote:
Incidentally, I looked at this stuff just a couple of days ago, and it
occurred to me that we really should make it easier to take a hot backup
with that mechanism. We shouldn't require setting up archive_command, and
WAL archiving, if all you want is to take a backup from a live system. From
user point of view, it should be a matter of:
1. call pg_start_backup('foo')
2. tar/etc. the whole data directory, except for pg_xlog
3. tar pg_xlog
4. call pg_stop_backup()
If we just made sure that we don't delete or recycle any WAL files while
the backup is being taken, that would work, right?
Or checkpoint, yes? I don't see tar backing up large (100+GB)
databases in < 5 minutes.
Right.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
