upgrade_5.4.x_to_6.0.x.md


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

# Zabbix Upgrade v5.4.x to v6.0.x (Debian 10, PostgreSQL, TimescaleDB)

## 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 repositroy 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