Remove Database Backups from core (move to appliance console)

[NickLaMuro]

For containers, we have a different process for doing database backups that doesn't make sense in appliance distributions of MIQ.

So it doesn't make to have a completely different process maintained in the core code base to handle backups, as well as having a toggle switch of sorts in the UI to disable database backups from being shown when in a container deployment.

As such, we are moving the responsibility of database backups to simply be a manageiq-appliance_console concern, and removing the need for the application (and the code base) to manage it.

In the process, we will also simplify the scope of responsibility to return to database backups only being done to a file location mounted on the system, which the user will have to setup themselves. This shouldn't remove the ability for connecting to S3, for example, as their are options like s3fs-fuse available for connecting to s3 via a mount, and for the other providers we have setup support for, options should be available for them as well. It does require a few more steps, but for a system admin this shouldn't be too much of an ask when compared with database backup management that already isn't handled by ManageIQ.

TODO

• Move PostgresAdmin out of manageiq-gems-pending (not being used else where)
  • Inject postgres admin into appliance console manageiq-appliance_console#153
  • Remove PostgresAdmin manageiq-gems-pending#516
• Implement a simple backup /scheduling menu in manageiq-appliance_console
  • remove calling run_rake and just call PostgresAdmin directly
  • simplify usage to just local file options (aka: delete a lot of code)
  • Use PostgresAdmin directly for DB backups manageiq-appliance_console#160
  • Add database dump/backup/restore to CLI manageiq-appliance_console#161
• New release of manageiq-appliance-console
  • ManageIQ/manageiq-appliance_console@e03d973
• Bump dependencies in manageiq-appliance-dependencies
  • Update manageiq-appliance_console to 7.0 manageiq-appliance#322
• (possibly) Delete FileDepot code in manageiq (might need to remove log backups as well)
  • [WIP] Delete DatabaseBackup/FileDepot/LogFile #21360
  • [WIP] Remove DatabaseBackup/FileDepot views manageiq-ui-classic#7816
• Delete FileStorage code in manageiq-gems-pending (will no longer be used)
  • [WIP] Remove/Extract File/Object storage classes manageiq-gems-pending#523
  • [WIP] Importing NFS/GlusterFS libs manageiq-smartstate#160
• Remove DatabaseBackup and EvmDatabaseOps code
  • Pull in .db_connections code from core manageiq-appliance_console#172
  • Release new version of manageiq-appliance_console
    • https://rubygems.org/gems/manageiq-appliance_console/versions/7.0.1
  • Remove DatabaseBackup #21415
  • Remove EvmDatabaseOps and related rake tasks #21384
  • Drop database_backups table manageiq-schema#607
  • [WIP] Remove DatabaseBackup/FileDepot views manageiq-ui-classic#7816
  • Delete DatabaseBackup related views manageiq-ui-classic#7943
• Document process for connecting/mounting to alternative file storage sources (s3, swift, etc.)

[Fryguy]

@NickLaMuro I wonder if we should a bullet for creating documentation for the current set of targets (e.g. explaining how to mount an s3fs-fuse mountpoint), or perhaps even just a subset of the more common ones.

[NickLaMuro]

Sure, I am cool with that idea. Will add.

[NickLaMuro]

Doesn't really fit into a bullet item, but I have created a repo I am using currently to test the appliance_console backups in a mostly automated fashion.

https://github.com/NickLaMuro/manageiq-db_backup-tests

It is a bit unwieldy to use so that is why it currently lives under my account, but am happy to move it somewhere that makes more sense. Also, the README is a bit outdated, so ignore that for the time being...

[Fryguy]

I didn't see any entry for the now-merged ManageIQ/manageiq-appliance_console#161 in the OP, but I wasn't sure where to add it.

Also, we need a release of the manageiq-appliance_console gem and possibly a bump for it in https://github.com/ManageIQ/manageiq-appliance/blob/master/manageiq-appliance-dependencies.rb

[NickLaMuro]

cc @bdunne ^

[bdunne]

Also, we need a release of the manageiq-appliance_console gem

I'll release a new version once we merge ManageIQ/manageiq-appliance_console#165