blob: f57ff756be08963ee0482e75d492ec3ebf34b829 (
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
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
|
# Zabbix Upgrade v5.4.x to v6.0.x (Debian 10, PostgreSQL, TimescaleDB)
Make sure to make a backup of the server(s) before you proceed.
## Upgrade TimescaleDB
### Install new timescaledb version
```
apt install timescaledb-2-2.6.0-postgresql-12
```
### Connect to Postgresql
```
sudo -u postgres psql -X
```
### Switch to database zabbix
```
\c zabbix
```
### Update the postgresql extension
```
ALTER EXTENSION timescaledb UPDATE;
```
### Verify that the new timescaledb version is used
```
\dx timescaledb
```
## Upgrade PostgreSQL to 14
### Install Postgresql 14
```
apt install postgresql-14
```
### Install Timescaledb
```
apt install timescaledb-2-2.6.0-postgresql-14
```
### Stop all postgresql clusters
```
service postgresql@12-main stop
```
```
service postgresql@14-main stop
```
### Drop the new postgresql cluster
```
pg_dropcluster 14 main
```
### Run pg_upgradecluster to upgrade the cluster to v14
```
pg_upgradecluster -v 14 --method=upgrade --link 12 main
```
### Make sure the new cluster ist listening on port 5432
```
netstat -tapen | grep LISTEN
```
### Drop the old postgresql cluster
```
pg_dropcluster 12 main
```
### Verify they timescaledb version on the zabbix db
```
sudo -u postgres psql
```
```
\c zabbix
```
```
\dx
```
## Upgrade Zabbix from 5.4.x to 6.0 (Steps for Debian 10)
### Remove the old repository list
```
rm -Rf /etc/apt/sources.list.d/zabbix.list
```
### Install the new repository list
```
wget https://repo.zabbix.com/zabbix/6.0/debian/pool/main/z/zabbix-release/zabbix-release_6.0-1+debian10_all.deb
```
```
dpkg -i zabbix-release_6.0-1+debian10_all.deb
```
### Update the repository cache
```
apt clean
```
```
apt update
```
### Verify that zabbix will be upgraded to v6
```
apt list --upgradeable
```
### Install all upgrades
```
apt ugprade
```
### Start zabbix Server
```
service zabbix-server start
```
### Check the log file for errors
```
vim /var/log/zabbix/zabbix_server.log
```
### Verify the web interface is up and running
## Enjoy using Zabbix :-)
|
