Home / server / Questions / 995134
Accepted
rawmain
Asked: 2019-12-11 22:17:54 +0800 CST

Use ansible initialize postgresql multiple times

  • 772

Make this task will work first time:

- name: Initialize the Database
  command: /usr/pgsql-9.6/bin/postgresql96-setup initdb

If run it second time, will got error:

fatal: [192.168.0.1]: FAILED! => {"changed": true, "cmd": ["/usr/pgsql-9.6/bin/postgresql96-setup", "initdb"], "delta": "0:00:00.017590", "end": "2019-12-11 06:08:49.999631", "msg": "non-zero return code", "rc": 1, "start": "2019-12-11 06:08:49.982041", "stderr": "", "stderr_lines": [], "stdout": "Data directory is not empty!", "stdout_lines": ["Data directory is not empty!"]}

How to avoid to run this task if it initialized database on the server already?

database

2 Answers

  1. Q: "stdout: Data directory is not empty!"

    A: 18.2. Creating a Database Cluster says:

    initdb will refuse to run if the data directory exists and already contains files; this is to prevent accidentally overwriting an existing installation.

    To make the command idempotent use the parameter creates, e.g.

        - name: Initialize the Database
      command: /usr/pgsql-9.6/bin/postgresql96-setup initdb
      args:
        creates: /usr/local/pgsql/data
    • 5
  2. Best Answer

    Check to see if the file/directory created by initdb is there first and if not, initdb.

    https://docs.ansible.com/ansible/latest/user_guide/playbooks_conditionals.html

    • 1