Ad Widget

Collapse

Zabbix with PostgreSQL

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • serge.fonville
    Junior Member
    • Jul 2007
    • 8

    #1

    Zabbix with PostgreSQL

    Today I decided to start over completely.

    I read about differences between MySQL and PostgreSQL, it seems to me that the latter better fits Zabbix' usage.
    There is just one huge issue (for now). Currently we are running CentOS 4.4 (as with all Linux our servers) and I have absolutely no idea how to porperly configure either (PostgreSQL and Zabbix).

    I installed PostgreSQL with:
    Code:
    yum install postgresql postgresql-contrib postgresql-devel \
    postgresql-docs postgresql-libs postgresql-pl postgresql-server php-pgsq
    libcurl and libcurl-devel are both 7.16.4 are downloaded form "http://curl.haxx.se/", curl 7.12.1 is installed via yum (otherwise Zabbix would complain about not being able to find libcurl.so.3) as is net-snmp and net-snmp-devel. PHP and Apache 2.0.59 both run fine.

    If I "su - postgres" I can import all the sql files without errors, unfortunately I want to use a zabbix user in postgres which only has full control over the zabbix database.
    Finally I need to configure the zabbix_server.conf to include PostgreSQL settings.

    Perhaps these questions are already answered, if so, please direct me.

    Most of this was easy when using MySQL, but it should be at least doable in PostgreSQL.

    Thanks a lot in advance.

    I will definitely keep using Zabbix (preferrably with PostgreSQL)
Working...