It can be done live thanks to PostgreSQLs MVCC but you may experience brief pauses to any operations that request a exclusive table lock on a table currently being backed up.
Also you may want to consider using an external PostgreSQL 9.x database for streaming replication. In 9.2 you can do cascading streaming replication which allows you to use pgpool as a proxy the connections, pool the connection (many to one connection), loadballance the reads, and automate your failover and live recovery of a cluster of 3 or more if 2 of them have quorum.
The one bathing about using 9.x is you need to recreate the links to the default PostgreSQL jdbc driver to the one for 9.x or you will run into errors.
-- Sent from my HP Pre3
On Mar 21, 2013 3:35 AM, Pierre Casenove <[email protected]> wrote:
Hello,
On the wiki, the following guide gives directions to backup oracle-xe:
I'm using, postgresql 8.4, and currently, I'm backing up the application using pg_dump command, to backup spacewalk database and postgres database.
pg_dump spaceschema -Fc -f /data/backup/spaceschema.dmp
pg_dump postgres -Fc -f /data/backup/postgres.dmp
Is it sufficient to recover the database in case of a crash?
Can the pg_dump be run with spacewalk running, or does it have to be a cold backup?
Thanks in advance,
Pierre
_______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
