Syntax Error with postgresql_query module

Archives Ansible Project
1

Hi, I have to create and populate a DB with Ansible.

I successfully create the db, but when I add the postgresql_query I got syntax error.
I also tried to add the code from documentation (here) but it get the same.

The error is:

The offending line appears to be:

  • name: Run queries from SQL script
    ^ here

I put here the playbook, I really have any idea what it could be. Is it a bug?

2

can you run it with -vvv ?

3

The output is:

4

SOLUTION FOUND
Sorry I’m very stupid and I shouldn’t work at night.

The problem is that postgresql_query is new in version 2.8 in development, and I have 2.7.10
Thank you for your time