Hi Pierre, while I'm unsure whether running the backup with Spacewalk up is save (thought, I would advise against it - just a feeling) I'd strongly recommend adding "-c" Param to the pg_dump, otherwise nasty things will happen - eg. a duplicated entry in the 'dual' table (created to allow imitation of the oracel 'dual' statements)
And this will seriously make your SW installation unusable when replaying the backup...IF you didn't drop it alltogether first. Best -Jonathan On 03/21/2013 08:30 AM, Pierre Casenove 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 ________________________________ Helmholtz Zentrum München Deutsches Forschungszentrum für Gesundheit und Umwelt (GmbH) Ingolstädter Landstr. 1 85764 Neuherberg www.helmholtz-muenchen.de Aufsichtsratsvorsitzende: MinDir´in Bärbel Brumme-Bothe Geschäftsführer: Prof. Dr. Günther Wess und Dr. Nikolaus Blum Registergericht: Amtsgericht München HRB 6466 USt-IdNr: DE 129521671
_______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
