Initial commit of PostgreSQL ansible role
Change-Id: Ieb82fed65ac8957058c4269182e1ea06f5bb87ee
diff --git a/molecule/default/verify.yml b/molecule/default/verify.yml
new file mode 100644
index 0000000..c5d854c
--- /dev/null
+++ b/molecule/default/verify.yml
@@ -0,0 +1,35 @@
+---
+# postgresql molecule/default/verify.yml
+#
+# SPDX-FileCopyrightText: © 2020 Open Networking Foundation <support@opennetworking.org>
+# SPDX-License-Identifier: Apache-2.0
+
+- name: Verify
+ hosts: all
+ tasks:
+
+ # user/pw/db defined in converge.yaml
+ # docs: https://docs.ansible.com/ansible/latest/modules/postgresql_ping_module.html
+ - name: Check that user can connect to database
+ postgresql_ping:
+ login_host: "localhost"
+ db: "exampledb"
+ login_user: "exampleuser"
+ login_password: "examplepass"
+
+ # docs: https://docs.ansible.com/ansible/latest/modules/postgresql_info_module.html
+ # default version is
+ - name: Check PostgreSQL Info
+ postgresql_info:
+ db: postgres
+ become: true
+ become_user: "postgres"
+ register: pgsql_info
+
+ # print entire pgsql_info if needed
+ # - debug: var=pgsql_info
+
+ - name: Verify PostgreSQL major version
+ assert:
+ that:
+ - pgsql_info['version']['major'] == 12