File: zabbix-server-pgsql.README.Debian

package info (click to toggle)
zabbix 1%3A7.0.10%2Bdfsg-2
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid, trixie
  • size: 272,688 kB
  • sloc: sql: 946,050; ansic: 389,440; php: 292,698; javascript: 83,388; sh: 5,680; makefile: 3,285; java: 1,420; cpp: 694; perl: 64; xml: 56
file content (29 lines) | stat: -rw-r--r-- 930 bytes parent folder | download | duplicates (2)
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
Installing the database
-----------------------

The Zabbix server needs an SQL database to run. As you chose to install
this zabbix-server-pgsql package you apparently want to use a PostgreSQL server
as a storage backend.

Set up PostgreSQL on any system - you are not forced to run it on the same
computer as the Zabbix server:

-> apt-get install postgresql

Create a new database and access user (let's call both "zabbix"). By default on
Debian systems you need to change to the "postgres" user:

-> su - postgres
-> createuser -SDRP zabbix
-> createdb -O zabbix zabbix
(You will get asked to enter a password for that new user account.)

Then send the necessary SQL files to the database
to create the required database schema:

-> zcat /usr/share/zabbix-server-pgsql/{schema,images,data}.sql.gz \
   | psql -h localhost zabbix zabbix

See also:

  https://www.zabbix.com/documentation/6.0/manual/appendix/install/db_scripts