So, assume I have a large DB (a few GBs) and I need to back up the data on a daily basis. When I initate a backup, I don't want to take it offline to do so, but I also must ensure that the snapshot of the DB at a given time is backed up. That is, I don't want my backup to be poluted by updates that make take place during the backup process.
Why? Assume it is accounting information and part of the disaster recovery is ensuring that a recovery is based on a given time when the DB was in a specific state.
Will pg_dump dump while the DB is still accepting updates, or are previous values in the DB cached so my backup is not polluted with subsequent changes? I believe Oracle supports this, but I would much rather use Pgsql... any thoughts?
Thanks in advance
Why? Assume it is accounting information and part of the disaster recovery is ensuring that a recovery is based on a given time when the DB was in a specific state.
Will pg_dump dump while the DB is still accepting updates, or are previous values in the DB cached so my backup is not polluted with subsequent changes? I believe Oracle supports this, but I would much rather use Pgsql... any thoughts?
Thanks in advance