<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">Hi Pierre,<br>
<br>
while I'm unsure whether running the backup with Spacewalk up is save (thought, I would advise against it - just a feeling)<br>
I'd strongly recommend adding "-c" Param to the pg_dump,<br>
otherwise nasty things will happen - eg. a duplicated entry in the 'dual' table (created to allow imitation of the oracel 'dual' statements)<br>
<br>
And this will seriously make your SW installation unusable when replaying the backup...IF you didn't drop it alltogether first.<br>
<br>
Best<br>
-Jonathan<br>
<br>
On 03/21/2013 08:30 AM, Pierre Casenove wrote:<br>
</div>
<blockquote cite="mid:CAALa77=P-y_P4MzLr=AMTQXaxBqQrcN0b8nMHhH=P2fMOEYqNg@mail.gmail.com" type="cite">
<meta http-equiv="Context-Type" content="text/html;
charset=iso-8859-1">
<div dir="ltr">Hello,
<div>On the wiki, the following guide gives directions to backup oracle-xe:</div>
<div><a moz-do-not-send="true" href="https://fedorahosted.org/spacewalk/wiki/SpacewalkBackup">https://fedorahosted.org/spacewalk/wiki/SpacewalkBackup</a><br>
</div>
<div><br>
</div>
<div>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.</div>
<div>pg_dump spaceschema -Fc -f /data/backup/spaceschema.dmp</div>
<div>pg_dump postgres -Fc -f /data/backup/postgres.dmp<br>
</div>
<div><br>
</div>
<div>Is it sufficient to recover the database in case of a crash?</div>
<div>Can the pg_dump be run with spacewalk running, or does it have to be a cold backup?</div>
<div><br>
</div>
<div>Thanks in advance,</div>
<div><br>
</div>
<div>Pierre</div>
</div>
</blockquote>
<br>
<hr>
<font face="Arial" color="Black" size="1">Helmholtz Zentrum München<br>
Deutsches Forschungszentrum für Gesundheit und Umwelt (GmbH)<br>
Ingolstädter Landstr. 1<br>
85764 Neuherberg<br>
www.helmholtz-muenchen.de<br>
Aufsichtsratsvorsitzende: MinDir´in Bärbel Brumme-Bothe<br>
Geschäftsführer: Prof. Dr. Günther Wess und Dr. Nikolaus Blum<br>
Registergericht: Amtsgericht München HRB 6466<br>
USt-IdNr: DE 129521671<br>
</font>
</body>
</html>