summaryrefslogtreecommitdiff
path: root/upgrade_6.0.x_to_7.0.x.md
blob: 872fccfb9f256789fa32e6b25427806671f81be4 (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
149
150
151
152
153
154
155
156
157
158
159
160
# Walkthrough ist work in progress, don't use by now

# Zabbix Upgrade v6.0.x to v7.0.x (Debian 12, PostgreSQL, TimescaleDB)

Make sure to make a backup of the server(s) before you proceed.

This instruction is assuming that you are using the following versions of software at the moment of the upgrade:

* Debian 10
* PostgreSQL v14
* TimescaleDB v2.6.0

## Upgrade Debian OS

Make sure to make a upgrade to Debian 12 before upgrading.

## 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 upgrade
```

### 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 :-)