Merge bootstack-ops:rt100872-maasdb-backup into bootstack-ops:master

[Jill Rouleau]

[Peter Sabaini (peter-sabaini)]

I realize that this MP isn't the only code in here sporting async/await constructs. But I still wonder if we should leave out trusty as a platform for our scripts -- as async/await only work in Python3.5+ which is not in the trusty repos?

[Jill Rouleau (jillrouleau)]

This backup script should only be deployed to new environments, it's replacing the old backup script that didn't work with juju2. So should be ok to depend on py3.5, confirmed w/ csanders on sync call.

[Drew Freiberger (afreiberger)]

review: Approve

diff --git a/bootstack-ops/backup.py b/bootstack-ops/backup.py
index ac85e29..464be31 100755
--- a/bootstack-ops/backup.py
+++ b/bootstack-ops/backup.py
@@ -6,6 +6,7 @@
 # *) Swift configuration and rings
 # *) MySQL (various OpenStack services)
 # *) PostgreSQL (Landscape)
+# *) PostgreSQL (MaaS db)
 
 import asyncio
 from juju.client.connection import JujuData
@@ -70,6 +71,19 @@ async def swift_backup(path, date):
     print("Done backing up swift.")
 
 
+async def maas_db_backup():
+
+    #Backup the psql db from this local maas server, need sudo/root to -U postgres
+    #Needs to have this permission in sudoers - do not give jujumanage full sudo access!
+    command = "sudo su - postgres -c pg_dumpall -U postgres | gzip > {}/maasdb-{}.gz".format( path, date )
+
+    print("Backing up maasdb with{}...").format( command )
+
+    await asyncio.create_subprocess_shell(command)
+
+    print("maasdb backed up")
+
+
 def main():
 
     parser = argparse.ArgumentParser(description='Backup key services for BootStack.')
@@ -87,6 +101,7 @@ def main():
     loop.run_until_complete(asyncio.gather(
         juju_backup(args.path, datestamp),
         juju_client_backup(args.path, datestamp),
+        maas_db_backup(args.path, datestamp)
         #swift_backup(args.path, datestamp)
     ))
     loop.close()