[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.

[Michael Mraka]

Post by 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

[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-***@redhat.com <spacewalk-list-***@redhat.com> On Behalf Of Michael Mraka
Sent: Wednesday, December 5, 2018 9:25 AM
To: spacewalk-***@redhat.com
Subject: Re: [Spacewalk-list] Metadata backups

Post by 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-***@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list