blob: d1d2137690d6c65cf543a4c880d2c5bc1f926ebd (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
|
do $$
declare
csr_name_central character varying := 'WELKTXEF-ROUTER-000004';
cluster_name_central character varying := 'welktxef-c000004-001';
ilo_hostname_central character varying := 'welktxef-000004-rh-p30e910-001';
oam_vip_hostname_central character varying := 'welktxef-000004-nh-pe1e910-001';
ilo_gateway_address_central character varying := '2607:f160:10:9051:ce:23::';
ilo_subnet_central character varying := '2607:f160:10:9051::';
oam_subnet_central character varying := '2607:f160:10:9051::';
oam_gateway_address_central character varying := ilo_gateway_address_central;
oam_floating_address_central character varying := '2607:f160:10:9051:ce:290:0:1000';
mgmt_start_address_central character varying := '2607:f160:10:9050:ce:290::';
mgmt_end_address_central character varying := '2607:f160:10:9050:ce:290:0:f';
mgmt_subnet_central character varying := '2607:f160:10:9050::';
mgmt_gateway_address_central character varying := '2607:f160:10:9050:ce:23::';
oam_hostname_central character varying := 'welktxef-000004-nh-pe2e910-001';
ilo_host_address_central character varying := '2607:f160:10:9221:ce:fe0:0:800b';
oam_host_address_central character varying := '2607:f160:10:9051:ce:290:0:1001';
begin
update caas_cellsiterouter
set ilo_subnet = ilo_subnet_central
where csr_hostname = csr_name_central;
update caas_cellsiterouter
set ilo_default_gateway = ilo_gateway_address_central
where csr_hostname = csr_name_central;
update caas_cellsiterouter
set oam_subnet = oam_subnet_central
where csr_hostname = csr_name_central;
update caas_cellsiterouter
set oam_default_gateway = oam_gateway_address_central
where csr_hostname = csr_name_central;
update caas_cellsiterouter
set mgmt_subnet = mgmt_subnet_central
where csr_hostname = csr_name_central;
update caas_cellsiterouter
set mgmt_default_gateway = mgmt_gateway_address_central
where csr_hostname = csr_name_central;
update caas_cluster
set oam_vip_hostname = oam_vip_hostname_central
where cluster_name = cluster_name_central;
update caas_cluster
set oam_vip_address = oam_floating_address_central
where cluster_name = cluster_name_central;
update caas_cluster
set mgmt_address_range_start = mgmt_start_address_central
where cluster_name = cluster_name_central;
update caas_cluster
set mgmt_address_range_end = mgmt_end_address_central
where cluster_name = cluster_name_central;
update caas_server
set oam_hostname = oam_hostname_central
where ilo_hostname = ilo_hostname_central;
update caas_server
set oam_host_address = oam_host_address_central
where ilo_hostname = ilo_hostname_central;
update caas_server
set ilo_host_address = ilo_host_address_central
where ilo_hostname = ilo_hostname_central;
end $$;
|
