blob: 6eb9cb7c334e24474f213d9b0e7e39ef5f9214a1 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
|
---
- set_fact:
postgres_dbname: "{{ postgres_pgupgrade.dbname }}"
postgres_pgbouncer_uri: "{{ postgres_pgupgrade.pgbouncer_uri|default(None) }}"
postgres_old_cluster_version: "{{ postgres_pgupgrade.old_cluster_version }}"
postgres_old_cluster_name: "{{ postgres_pgupgrade.old_cluster_name }}"
postgres_new_cluster_version: "{{ postgres_pgupgrade.new_cluster_version }}"
postgres_new_cluster_name: "{{ postgres_pgupgrade.new_cluster_name }}"
postgres_standby_server: "{{ postgres_pgupgrade.standby_server }}"
postgres_standby_old_cluster_name: "{{ postgres_pgupgrade.standby_old_cluster_name|default(postgres_pgupgrade.old_cluster_name) }}"
postgres_standby_new_cluster_name: "{{ postgres_pgupgrade.standby_new_cluster_name|default(postgres_pgupgrade.new_cluster_name) }}"
- name: Find matching new cluster
set_fact:
postgres_new_cluster: "{{ postgres_clusters|selectattr('name','equalto',postgres_new_cluster_name)|selectattr('version','equalto', postgres_new_cluster_version|float)|list|first }}"
- name: Extract database port of new matching cluster
set_fact:
postgres_new_cluster_port: "{{ (postgres_new_cluster|default({'port': 5432}))['port'] }}"
- name: Upload pg_upgrade.sh script
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
no_log: True
|
