Ad Widget

Collapse

Initial DB install PgSQL

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • pimp_vader
    Junior Member
    • Oct 2014
    • 12

    #1

    Initial DB install PgSQL

    I am not finding what I am looking for in the Zabbix 3.4 documentation so I am turning to the community.

    I have a new set up of zabbix3.4, the master, database, and web server are all housed on separate hardware. I have built instances with all the pieces on a single piece of hardware but never distributed like this. My question is how do I import the initial schema to a remote database? Is it as simple as adding the appropriate information to the DB conf settings in zabbix_server.conf?

    TIA
    ~Jason
  • albatrosdk
    Junior Member
    • Mar 2018
    • 11

    #2
    you should probaly copy the schema file to the remote database server and then do the pgsql insert on there.

    Comment

    • pimp_vader
      Junior Member
      • Oct 2014
      • 12

      #3
      [SOLVED]

      Had to create an empty DB on the remote PostgreSQL server with the name zabbix and give the zabbix user all privileges to that database then make sure that my account had the necessary access in sudoers to execute commands as zabbix on the master, once those dependencies were met I ran

      Code:
      zcat /usr/share/doc/zabbix-server-pgsql-3.4.7/create.sql.gz | sudo -u zabbix psql -h <DATABASE_HOST> -U zabbix
      then the DB built on the remote server without issue and I was able to connect to the DB with the Master and the Frontend servers

      Comment

      Working...