*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
Il giorno venerdì 3 maggio 2019 21:52:58 UTC+2, [email protected] ha scritto: > > 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 > <https://docs.ansible.com/ansible/devel/modules/postgresql_query_module.html>) > > 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? > >> >>> - hosts: vm_database >> >> become: yes >> >> vars: >> >> #usate per il lancio senza Cloudify >> >> an_db_name: db_webserver >> >> #an_db_user: webserver >> >> #an_db_password: webserver >> >> tasks: >> >> - name: PostgreSQL installation... >> >> become_user: root >> >> package: >> >> name: "{{ item }}" >> >> state: present >> >> loop: >> >> - postgresql >> >> #- postgresql-contrib >> >> #- libpq-dev >> >> - python-psycopg2 >> >> >>> - name: Check Cluster dir is empty.. >> >> register: foundFiles >> >> find: >> >> paths: /var/lib/postgres/data >> >> patterns: '*.*' >> >> >>> - name: Launching initdb ... >> >> when: foundFiles.matched == 0 >> >> become_user: postgres >> >> become_flags: -i >> >> shell: initdb --locale $LANG -E UTF8 -D '/var/lib/postgres/data' >> >> >>> - name: Set postgresql.conf to allow remote connection... >> >> become_user: root >> >> lineinfile: >> >> path: /var/lib/postgres/data/postgresql.conf >> >> regexp: "^#listen_addresses = 'localhost'" >> >> line: "listen_addresses = '*' " >> >> >>> - name: Set pg_hba.conf to allow remote connection... >> >> become_user: root >> >> lineinfile: >> >> path: /var/lib/postgres/data/pg_hba.conf >> >> regexp: 'host.*all.*all.*0.0.0.0/0.*md5' #da sistemare, non >>> funziona >> >> firstmatch: yes >> >> insertafter: '^# IPv4 local connections:*' >> >> line: "host\tall\t\tall\t\t0.0.0.0/0\t\tmd5" #controllare >>> -> bazooka >> >> >>> - name: Service launch.. >> >> become_user: root >> >> service: >> >> name: postgresql >> >> state: started >> >> enabled: yes >> >> >>> - name:DB creation.. >> >> become_user: postgres >> >> postgresql_db: >> >> name: "{{ an_db_name }}" >> >> encoding: UTF-8 >> >> lc_collate: it_IT.UTF-8 >> >> lc_ctype: it_IT.UTF-8 >> >> template: template0 >> >> state: present >> >> >>> - name: User creation.. >> >> become_user: postgres >> >> postgresql_user: >> >> db: "{{ an_db_name }}" >> >> name: "{{ an_db_user }}" >> >> password: "{{ an_db_password }}" >> >> priv: ALL >> >> role_attr_flags: LOGIN,CREATEDB >> >> state: present >> >> ###EVERYTHING FINE TILL HERE#### >> >> *- name: Run queries from SQL script...* >> >> * become_user: postgres* >> >> * postgresql_query:* >> >> * db: "{{ an_db_name }}"* >> >> * path_to_script: Resource/00-create.sql* >> >> * positional_args: 1* >> >> -- You received this message because you are subscribed to the Google Groups "Ansible Project" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/718f0f2a-6c27-4dae-9ed1-9853304d7b1a%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
