File: zabbix-server-pgsql.README.Debian

package info (click to toggle)
zabbix 1%3A5.0.8%2Bdfsg-1
  • links: PTS, VCS
  • area: main
  • in suites: bullseye
  • size: 135,196 kB
  • sloc: ansic: 250,674; sql: 209,763; php: 195,264; xml: 167,194; javascript: 46,671; sh: 5,339; makefile: 1,723; java: 1,337; cpp: 620; perl: 41
file content (29 lines) | stat: -rw-r--r-- 917 bytes parent folder | download
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
-> createdb zabbix
-> createuser -SDRP 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:
http://www.zabbix.com/documentation/5.0/manual/appendix/install/db_scripts