]>
Commit | Line | Data |
---|---|---|
d0bc90e0 | 1 | --- |
f1a9ab46 P |
2 | - set_fact: |
3 | postgres_dbname: "{{ postgres_pgupgrade.dbname }}" | |
4 | postgres_pgbouncer_uri: "{{ postgres_pgupgrade.pgbouncer_uri|default(None) }}" | |
5 | postgres_old_cluster_version: "{{ postgres_pgupgrade.old_cluster_version }}" | |
6 | postgres_old_cluster_name: "{{ postgres_pgupgrade.old_cluster_name }}" | |
7 | postgres_new_cluster_version: "{{ postgres_pgupgrade.new_cluster_version }}" | |
8 | postgres_new_cluster_name: "{{ postgres_pgupgrade.new_cluster_name }}" | |
9 | postgres_standby_server: "{{ postgres_pgupgrade.standby_server }}" | |
10 | postgres_standby_old_cluster_name: "{{ postgres_pgupgrade.standby_old_cluster_name|default(postgres_pgupgrade.old_cluster_name) }}" | |
11 | postgres_standby_new_cluster_name: "{{ postgres_pgupgrade.standby_new_cluster_name|default(postgres_pgupgrade.new_cluster_name) }}" | |
12 | ||
d0bc90e0 P |
13 | - name: Find matching new cluster |
14 | set_fact: | |
f1a9ab46 | 15 | postgres_new_cluster: "{{ postgres_clusters|selectattr('name','equalto',postgres_new_cluster_name)|selectattr('version','equalto', postgres_new_cluster_version|float)|list|first }}" |
d0bc90e0 P |
16 | |
17 | - name: Extract database port of new matching cluster | |
18 | set_fact: | |
19 | postgres_new_cluster_port: "{{ (postgres_new_cluster|default({'port': 5432}))['port'] }}" | |
20 | ||
21 | - name: Upload pg_upgrade.sh script | |
22 | template: src=pg_upgrade.sh.j2 dest=/var/lib/postgresql/pg_upgrade_{{ postgres_old_cluster_version }}_{{ postgres_new_cluster_version }}_{{ postgres_dbname }} owner=postgres group=postgres mode=0700 | |
23 | no_log: True |