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/5d7c4e35-e113-4e0d-a929-905ea73b8d74%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
