[Spacewalk-list] Backing Spacewalk

[Jonathan Hoser]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20130321/c53dcd10/attachment.htm>