{"id":10101,"date":"2022-05-25T03:02:19","date_gmt":"2022-05-25T03:02:19","guid":{"rendered":"https:\/\/www.insentragroup.com\/us\/?p=10101"},"modified":"2024-12-13T02:01:30","modified_gmt":"2024-12-13T02:01:30","slug":"how-to-change-the-database-name-for-ansible-tower-or-awx","status":"publish","type":"post","link":"https:\/\/www.insentragroup.com\/us\/insights\/geek-speak\/modern-workplace\/how-to-change-the-database-name-for-ansible-tower-or-awx\/","title":{"rendered":"How to change the database name for Ansible Tower (or AWX)"},"content":{"rendered":"\n

1. Stop Ansible Tower daemons on all AT nodes: <\/p>\n\n\n\n

ansible-tower-service stop <\/code><\/pre>\n\n\n\n
2. Use psql to connect to the DB: <\/p>\n\n\n\n
psql \"host=dbname01.postgres.database.azure.com port=5432 dbname=postgres user=dbname01admin@dbname01 password=<your_pass> sslmode=require\"<\/code><\/pre>\n\n\n\n
3. List available databases: <\/p>\n\n\n\n
postgres=> \\l \n\nList of databases\n\n Name          |        Owner        | Encoding |          Collate           |           Ctype            |          Access privileges \n\n-----------------------+---------------------+----------+----------------------------+----------------------------+------------------------------------- \n\n awx                   | dbname01admin | UTF8     | en-US                      | en-US            <\/code><\/pre>\n\n\n\n
4. Rename the existing awx db to awx2 (postgres will not allow you to do any changes if there are any Ansible Tower daemons running and connecting to the database):  <\/p>\n\n\n\n
postgres=> alter database awx rename to awx2; <\/code><\/pre>\n\n\n\n
5. Confirm the db has been renamed: <\/p>\n\n\n\n
postgres=> \\l \n\n         List of databases\n\n Name          |        Owner        | Encoding |          Collate           |           Ctype            |          Access privileges \n\n-----------------------+---------------------+----------+----------------------------+----------------------------+------------------------------------- \n\n awx2                  | dbname01admin | UTF8     | en-us                      | en-us <\/code><\/pre>\n\n\n\n
6. Create a new awx db if required (this step is required if you would like to use awx database as a target to restore from the postgresql dump):  <\/p>\n\n\n\n
postgres=> CREATE DATABASE awx WITH TEMPLATE = template0 ENCODING = 'UTF8' LC_COLLATE = 'en-US' LC_CTYPE = 'en-US'; <\/code><\/pre>\n\n\n\n
7 . Update the \/etc\/tower\/conf.d\/postgres.py on all the nodes: <\/p>\n\n\n\n
FROM: <\/p>\n\n\n\n
# Ansible Tower database settings. \n\n \n\nDATABASES = { \n\n   'default': { \n\n       'ATOMIC_REQUESTS': True, \n\n       'ENGINE': 'awx.main.db.profiled_pg', \n\n       'NAME': 'awx', \n\n       'USER': 'dbname01admin@dbname01', \n\n       'PASSWORD': \"\"\"PASSWORD\"\"\", \n\n       'HOST': 'dbname01.postgres.database.azure.com', \n\n       'PORT': '5432', \n\n       'OPTIONS': { 'sslmode': 'prefer', \n\n                    'sslrootcert': '\/etc\/pki\/tls\/certs\/ca-bundle.crt', \n\n       }, \n\n   } \n\n} <\/code><\/pre>\n\n\n\n
TO: <\/p>\n\n\n\n
# Ansible Tower database settings. \n\n \n\nDATABASES = { \n\n   'default': { \n\n       'ATOMIC_REQUESTS': True, \n\n       'ENGINE': 'awx.main.db.profiled_pg', \n\n       'NAME': 'awx2', \n\n       'USER': 'dbname01admin@dbname01', \n\n       'PASSWORD': \"\"\"PASSWORD\"\"\", \n\n       'HOST': 'dbname01.postgres.database.azure.com', \n\n       'PORT': '5432', \n\n       'OPTIONS': { 'sslmode': 'prefer', \n\n                    'sslrootcert': '\/etc\/pki\/tls\/certs\/ca-bundle.crt', \n\n       }, \n\n   } \n\n} <\/code><\/pre>\n\n\n\n
8. Start the ansible tower on all nodes: <\/p>\n\n\n\n
ansible-tower-service start <\/code><\/pre>\n\n\n\n
9. Verify the nodes: <\/p>\n\n\n\n
# awx-manage list_instances \n\n[tower capacity=411] \n\n        node01 capacity=137 version=3.8.4 heartbeat=\"2021-11-19 02:39:07\" \n\n        node02 capacity=137 version=3.8.4 heartbeat=\"2021-11-19 02:39:15\" \n\n        node03 capacity=137 version=3.8.4 heartbeat=\"2021-11-19 02:38:57\" <\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
This step-by step guide show you how to change the database Name for Ansible Tower (or AWX).<\/p>\n","protected":false},"author":67,"featured_media":10103,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"content-type":"","footnotes":""},"categories":[19],"tags":[],"class_list":["post-10101","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-modern-workplace","entry"],"_links":{"self":[{"href":"https:\/\/www.insentragroup.com\/us\/wp-json\/wp\/v2\/posts\/10101","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.insentragroup.com\/us\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.insentragroup.com\/us\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.insentragroup.com\/us\/wp-json\/wp\/v2\/users\/67"}],"replies":[{"embeddable":true,"href":"https:\/\/www.insentragroup.com\/us\/wp-json\/wp\/v2\/comments?post=10101"}],"version-history":[{"count":2,"href":"https:\/\/www.insentragroup.com\/us\/wp-json\/wp\/v2\/posts\/10101\/revisions"}],"predecessor-version":[{"id":10474,"href":"https:\/\/www.insentragroup.com\/us\/wp-json\/wp\/v2\/posts\/10101\/revisions\/10474"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.insentragroup.com\/us\/wp-json\/wp\/v2\/media\/10103"}],"wp:attachment":[{"href":"https:\/\/www.insentragroup.com\/us\/wp-json\/wp\/v2\/media?parent=10101"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.insentragroup.com\/us\/wp-json\/wp\/v2\/categories?post=10101"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.insentragroup.com\/us\/wp-json\/wp\/v2\/tags?post=10101"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}