greenplum一次修改主机名的经历

来源：互联网发布：欠淘宝贷款3年都没还上编辑：程序博客网时间：2024/05/17 08:55

1.原集群信息如下:

postgres=# select * from gp_segment_configuration;
dbid | content | role | preferred_role | mode | status | port | hostname | address | replication_port | san_mounts
------+---------+------+----------------+------+--------+-------+----------+---------+------------------+------------
10 | 8 | p | p | s | u | 40000 | gp-s0008 | sdw8 | 41000 |
11 | 9 | p | p | s | u | 40001 | gp-s0008 | sdw8 | 41001 |
12 | 10 | p | p | s | u | 40002 | gp-s0008 | sdw8 | 41002 |
13 | 11 | p | p | s | u | 40003 | gp-s0008 | sdw8 | 41003 |
26 | 8 | m | m | s | u | 50000 | gp-s0009 | sdw9 | 51000 |
27 | 9 | m | m | s | u | 50001 | gp-s0009 | sdw9 | 51001 |
28 | 10 | m | m | s | u | 50002 | gp-s0009 | sdw9 | 51002 |
29 | 11 | m | m | s | u | 50003 | gp-s0009 | sdw9 | 51003 |
1 | -1 | p | p | s | u | 2345 | sdw7 | sdw7 | |
6 | 4 | p | p | s | u | 40000 | gp-s0007 | sdw7 | 41000 |
22 | 4 | m | m | s | u | 50000 | gp-s0008 | sdw8 | 51000 |
7 | 5 | p | p | s | u | 40001 | gp-s0007 | sdw7 | 41001 |
23 | 5 | m | m | s | u | 50001 | gp-s0008 | sdw8 | 51001 |
8 | 6 | p | p | s | u | 40002 | gp-s0007 | sdw7 | 41002 |
24 | 6 | m | m | s | u | 50002 | gp-s0008 | sdw8 | 51002 |
9 | 7 | p | p | s | u | 40003 | gp-s0007 | sdw7 | 41003 |
25 | 7 | m | m | s | u | 50003 | gp-s0008 | sdw8 | 51003 |
2 | 0 | p | p | s | u | 40000 | gp-s0010 | sdw10 | 41000 |
18 | 0 | m | m | s | u | 50000 | gp-s0007 | sdw7 | 51000 |
3 | 1 | p | p | s | u | 40001 | gp-s0010 | sdw10 | 41001 |
19 | 1 | m | m | s | u | 50001 | gp-s0007 | sdw7 | 51001 |
4 | 2 | p | p | s | u | 40002 | gp-s0010 | sdw10 | 41002 |
20 | 2 | m | m | s | u | 50002 | gp-s0007 | sdw7 | 51002 |
5 | 3 | p | p | s | u | 40003 | gp-s0010 | sdw10 | 41003 |
21 | 3 | m | m | s | u | 50003 | gp-s0007 | sdw7 | 51003 |
14 | 12 | p | p | s | u | 40000 | gp-s0009 | sdw9 | 41000 |
30 | 12 | m | m | s | u | 50000 | gp-s0010 | sdw10 | 51000 |
15 | 13 | p | p | s | u | 40001 | gp-s0009 | sdw9 | 41001 |
31 | 13 | m | m | s | u | 50001 | gp-s0010 | sdw10 | 51001 |
16 | 14 | p | p | s | u | 40002 | gp-s0009 | sdw9 | 41002 |
32 | 14 | m | m | s | u | 50002 | gp-s0010 | sdw10 | 51002 |
17 | 15 | p | p | s | u | 40003 | gp-s0009 | sdw9 | 41003 |
33 | 15 | m | m | s | u | 50003 | gp-s0010 | sdw10 | 51003 |

2.由于重新规划，需要重新修改主机名

gp-s0009=====>portal-db3

gp-s0010=====>portal-db4

3.操作步骤：

(1) gpstop -M fast

(2) 修改主机名后，修改所有服务器上的/etc/hosts（如果必要，重新进行密钥交互）

(3) gpstart -m

(4) PGOPTIONS='-c gp_session_role=utility' psql -U gpadmin postgres

>set allow_system_table_mods='dml';

>update gp_segment_configuration set hostname='portal-db3' where address='sdw9';

>update gp_segment_configuration set hostname='portal-db4' where address='sdw10';

(5) gpstop -m

(6) gpstart -a

集群成功启动，而且节点信息也全部正确。

4.查询新的集群信息：

haieredw=# select * from gp_segment_configuration;
dbid | content | role | preferred_role | mode | status | port | hostname | address | replication_port | san_mounts
------+---------+------+----------------+------+--------+-------+------------+---------+------------------+------------
10 | 8 | p | p | s | u | 40000 | gp-s0008 | sdw8 | 41000 |
11 | 9 | p | p | s | u | 40001 | gp-s0008 | sdw8 | 41001 |
12 | 10 | p | p | s | u | 40002 | gp-s0008 | sdw8 | 41002 |
13 | 11 | p | p | s | u | 40003 | gp-s0008 | sdw8 | 41003 |
22 | 4 | m | m | s | u | 50000 | gp-s0008 | sdw8 | 51000 |
23 | 5 | m | m | s | u | 50001 | gp-s0008 | sdw8 | 51001 |
24 | 6 | m | m | s | u | 50002 | gp-s0008 | sdw8 | 51002 |
25 | 7 | m | m | s | u | 50003 | gp-s0008 | sdw8 | 51003 |
26 | 8 | m | m | s | u | 50000 | portal-db3 | sdw9 | 51000 |
27 | 9 | m | m | s | u | 50001 | portal-db3 | sdw9 | 51001 |
28 | 10 | m | m | s | u | 50002 | portal-db3 | sdw9 | 51002 |
29 | 11 | m | m | s | u | 50003 | portal-db3 | sdw9 | 51003 |
14 | 12 | p | p | s | u | 40000 | portal-db3 | sdw9 | 41000 |
15 | 13 | p | p | s | u | 40001 | portal-db3 | sdw9 | 41001 |
16 | 14 | p | p | s | u | 40002 | portal-db3 | sdw9 | 41002 |
17 | 15 | p | p | s | u | 40003 | portal-db3 | sdw9 | 41003 |
2 | 0 | p | p | s | u | 40000 | portal-db4 | sdw10 | 41000 |
3 | 1 | p | p | s | u | 40001 | portal-db4 | sdw10 | 41001 |
4 | 2 | p | p | s | u | 40002 | portal-db4 | sdw10 | 41002 |
5 | 3 | p | p | s | u | 40003 | portal-db4 | sdw10 | 41003 |
30 | 12 | m | m | s | u | 50000 | portal-db4 | sdw10 | 51000 |
31 | 13 | m | m | s | u | 50001 | portal-db4 | sdw10 | 51001 |
32 | 14 | m | m | s | u | 50002 | portal-db4 | sdw10 | 51002 |
33 | 15 | m | m | s | u | 50003 | portal-db4 | sdw10 | 51003 |
1 | -1 | p | p | s | u | 2345 | gp-s0007 | sdw7 | |
6 | 4 | p | p | s | u | 40000 | gp-s0007 | sdw7 | 41000 |
7 | 5 | p | p | s | u | 40001 | gp-s0007 | sdw7 | 41001 |
8 | 6 | p | p | s | u | 40002 | gp-s0007 | sdw7 | 41002 |
9 | 7 | p | p | s | u | 40003 | gp-s0007 | sdw7 | 41003 |
18 | 0 | m | m | s | u | 50000 | gp-s0007 | sdw7 | 51000 |
19 | 1 | m | m | s | u | 50001 | gp-s0007 | sdw7 | 51001 |
20 | 2 | m | m | s | u | 50002 | gp-s0007 | sdw7 | 51002 |
21 | 3 | m | m | s | u | 50003 | gp-s0007 | sdw7 | 51003 |

阅读全文

0 0