def run_deploy():
args = Args()
if not args.try_configure_connect_to_pg():
sys.exit(1)
if not Pooler.is_superuser():
sys.stderr.write("ERROR: Bootstrap must be run by PostgreSQL superuser\n")
sys.exit(1)
try:
for sql in CreateSchemaSQL.split(QuerySplit):
if args.args.verbose:
sys.stdout.write("\nExecuting query:\n{0}\n".format(sql))
Pooler.query(sql)
except Exception as e:
sys.stderr.write("Query:\n{0}\nerror: {1}\n".format(sql, e))
sys.exit(2)
try:
for sql in GrantsOnSchemaSQL.format(
mamonsu_version.replace('.', '_'), args.args.mamonsu_username).split(QuerySplit):
if args.args.verbose:
sys.stdout.write("\nExecuting query:\n{0}\n".format(sql))
Pooler.query(sql)
except Exception as e:
sys.stderr.write("Query:\n{0}\nerror: {1}\n".format(sql, e))
sys.exit(2)
sys.stdout.write("Bootstrap successfully completed\n")
def run_deploy():
args = Args()
if not args.try_configure_connect_to_pg():
sys.exit(1)
if not Pooler.is_superuser():
sys.stderr.write(
"ERROR: Bootstrap must be run by PostgreSQL superuser\n")
sys.exit(1)
try:
for sql in CreateSchemaSQL.format(
mamonsu_version,
mamonsu_version.replace('.', '_'),
'[0-9A-F]{24}',
'wal' if Pooler.server_version_greater('10.0') else 'xlog',
'wal_lsn' if Pooler.server_version_greater('10.0') else 'xlog_location',
'waiting' if Pooler.server_version_less('9.6.0') else 'case when wait_event_type is null then false '
' else true end as waiting'
).split(QuerySplit):
if args.args.verbose:
sys.stdout.write("\nExecuting query:\n{0}\n".format(sql))
Pooler.query(sql)
except Exception as e:
sys.stderr.write("Query:\n{0}\nerror: {1}\n".format(sql, e))
sys.exit(2)
try:
for sql in GrantsOnSchemaSQL.format(
mamonsu_version.replace('.', '_'),
args.args.mamonsu_username,
'wal' if Pooler.server_version_greater('10.0') else 'xlog'
).split(QuerySplit):
if args.args.verbose:
sys.stdout.write("\nExecuting query:\n{0}\n".format(sql))
Pooler.query(sql)
except Exception as e:
sys.stderr.write("Query:\n{0}\nerror: {1}\n".format(sql, e))
sys.exit(2)
sys.stdout.write("Bootstrap successfully completed\n")
