[Spacewalk-list] Metadata backups

[William Hongach]

Hi Michael,

Thank you for the prompt reply.  I was not aware db-control but this is exactly what I was looking for.  I will read up further on its usage.  Have a great day.

-----Original Message-----
From: spacewalk-list-bounces at redhat.com <spacewalk-list-bounces at redhat.com> On Behalf Of Michael Mraka
Sent: Wednesday, December 5, 2018 9:25 AM
To: spacewalk-list at redhat.com
Subject: Re: [Spacewalk-list] Metadata backups

William Hongach:
> Good Morning,
> 
> I am looking to back up the pgsql database that stores Spacewalk metadata.  I used most (if not all) of the default options upon installation, and I want to make sure that I dump the correct databases during back up.
> 
> Will a dump of the "postgres" and "rhnschema" databases be sufficient for recovery if we need to restore the Spacewalk metadata to a specific point in time?  The physical file system that Spacewalk uses is already being backed up.
> 
> Should template0 and template1 also be backed up?  Thanks in advance.

Hello William,

Spacewalk contains 'db-control' script for database manipulation. You can just use
  # db-control backup /backupdir
or
  # db-control online-backup  /backupdir/dbbackup.dump

and
  # db-control restore /backupdir/dbbackup.dump


Regards,

--
Michael Mráka
System Management Engineering, Red Hat

_______________________________________________
Spacewalk-list mailing list
Spacewalk-list at redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list