This repository has been archived by the owner on Jul 23, 2024. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 327
/
README
76 lines (50 loc) · 2.56 KB
/
README
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
73
74
75
Fresh installation from 3.0.0.0 source code
-------------------------------------------
1. Compile ORC format in pluggable storage framework
$ ./configure --with-orc; make -j8; make install
2. Configure and initialize cluster
$ hawq init cluster -a
Fresh installation from 3.0.0.0 rpm package
-------------------------------------------
1. Setup 3.0.0.0 yum repository
2. Install rpm package
$ sudo yum install -y hawq
3. Configure and initialize cluster
$ hawq init cluster -a
Upgrade from 2.2.0.0 to 3.3.0.0
-------------------------------
1. Stop 2.2.0.0 cluster on master node
$ hawq stop cluster -a
2. Backup 2.2.0.0 configuration on each node
$ cp -rf $GPHOME/etc ~/
3. Backup 2.2.0.0 yum repository on each node
4. Setup 3.0.0.0 yum repository on each node
5. Install 3.0.0.0 rpm package on each node
$ sudo yum remove -y hawq
$ sudo yum install -y hawq
6. Configure 3.0.0.0 on each node
$ cp -rf ~/etc/* $GPHOME/etc/
7. Install ORC format
1) Configure the cluster to upgrade mode
$ hawq start cluster
$ hawq config -c upgrade_mode -v on --skipvalidation
$ hawq restart cluster -a
2) Install ORC format in pg_catalog.pg_proc table in template1 on master node
Please find $hawq_master_address_port in $GPHOME/etc/hawq-site.xml
$ PGOPTIONS='-c gp_session_role=utility' psql -a -p $hawq_master_address_port -d template1 -f $GPHOME/share/postgresql/orc_install.sql > orc_install.out 2>&1
3) Install ORC format in pg_catalog.pg_proc table in template1 on segment node
Please find $hawq_segment_address_port in $GPHOME/etc/hawq-site.xml
$ PGOPTIONS='-c gp_session_role=utility' psql -a -p $hawq_segment_address_port -d template1 -f $GPHOME/share/postgresql/orc_install.sql > orc_install.out 2>&1
4) Configure the cluster to normal mode
$ hawq config -c upgrade_mode -v off --skipvalidation
$ hawq restart cluster -a
5) Get user database name on master node
$ psql -a -d template1 -c "select datname from pg_database where datname not in ('hcatalog', 'template0', 'template1') order by datname;"
6) Install ORC format in pg_catalog.pg_proc table in each user database on master node
$ psql -a -d $user_database_name -f $GPHOME/share/postgresql/orc_install.sql > orc_install.out 2>&1
7) Restart cluster on master node
$ hawq restart cluster -a
8. Uninstall ORC format if necessary
Refer to installation of ORC format while use /user/local/hawq/share/postgresql/orc_uninstall.sql instead of /user/local/hawq/share/postgresql/orc_install.sql
9. Install PostGIS if necessary
10. Install MADlib if necessary