Thanks a lot for the advices. I've added the -c switch to pgdump command. Pierre Le 21 mars 2013 14:15, "Paul Robert Marino" <[email protected]> a écrit :
> I'll check the flags latter but yes pgdump is the right tool. > 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: > https://fedorahosted.org/spacewalk/wiki/SpacewalkBackup > > 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 >
_______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
