DS
Size: a a a
DS
NK
- name: Remove PostgreSQL user
become: yes
become_user: postgres
postgresql_user:
db: "{{ username }}"
user: "{{ username }}"
state: absent
t
AT
S
AT
S
AT
NZ
- name: Wait for close all ESTABLISHED connection to instance.
wait_for:
active_connection_states: ['ESTABLISHED']
host: 127.0.0.1
port: 8080
state: stopped
timeout: 60
delay: 5
NZ
NZ
state: drained
работает на мне и нужно.NK
NK
AK
NK
NK
NK
- name: Remove PostgreSQL db
become: yes
become_user: postgres
postgresql_db:
name: "{{ username }}"
state: absent
when: dbtype == "pg"
- name: Create db PostgreSQL
become: yes
become_user: postgres
postgresql_db:
name: "{{ dbname }}"
encoding: UTF-8
template: template0
state: present
when: dbtype == "pg"
NK
- name: Dump Databases PostgreSQL
become: yes
become_user: postgres
postgresql_db :
name: "{{ copy_dbname }}"
state: dump
target: "/tmp/{{ copy_dbname }}.sql"
when: dbtype == "pg"
NK
- name: Import databases PostgreSQL
become: yes
become_user: postgres
shell: "psql {{ dbname }} < /tmp/{{ copy_dbname }}.sql"
when: dbtype == "pg"
NK