I'm finding lots of examples of how to manage posgresql with ansible (Linux), however, all of them contain the most basic things (install package, start service, create db, create user), but not the most important thing: create the tables.
I have a SQL file with the tables for my database but I don't know how to properly use it as an input in my ansible role. I'm hoping I don't need to use the shell module to just execute the SQL, because as far as I understand that's a no-no in the ansible world (especially because we may need a way first to check if the tables have already been created in a previous run).
How to do this? Any sample out there? Cheers
Best Answer
Usually it is an application's task to manage tables inside a given database(schema), that's why there are no modules to work with tables from Ansible.
You are correct that you should avoid
shellmodule if native module for the task in question exists. But if there is no such module,shellis an OK choice.You can check this answer https://stackoverflow.com/a/39117576/2795592 to get an idea of how to create idempotent script that creates something inside postgres.