File: zabbix-proxy-pgsql.README.Debian

package info (click to toggle)
zabbix 1%3A6.0.14%2Bdfsg-1
  • links: PTS, VCS
  • area: main
  • in suites: bookworm
  • size: 283,384 kB
  • sloc: sql: 868,673; ansic: 322,351; php: 235,311; javascript: 62,116; sh: 5,555; makefile: 2,257; java: 1,397; cpp: 662; xml: 49; perl: 41
file content (30 lines) | stat: -rw-r--r-- 891 bytes parent folder | download | duplicates (3)
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
Installing the database
-----------------------

The Zabbix proxy needs an SQL database to run. As you chose to install
this zabbix-proxy-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 proxy:

-> 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-proxy-pgsql/schema.sql.gz \
   | psql zabbix zabbix

See also:

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