Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-4145

psql 9.1 installation issues

    XMLWordPrintable

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 1.8.7, 1.9.6 (beta)
    • Fix Version/s: 2.0.0
    • Component/s: None
    • Environment:
      Centos 6.0 x64, PostgreSQL9.1

      Description

      hello

      i've tried to install zabbix on the server with psql as DB engine. I've tried 2 versions of zabbix latest stable 1.8.7 and 1.9.6 beta. both installation failed on DB setup step
      [root@zabbix data]# cat images_pgsql.sql | psql -U zabbix zabbix
      invalid command \
      invalid command \
      invalid command \
      invalid command \
      invalid command \'
      invalid command \'
      invalid command \
      invalid command \
      invalid command \
      invalid command \'
      invalid command \
      invalid command \
      invalid command \
      invalid command \
      invalid command \
      invalid command \
      invalid command \
      invalid command \
      invalid command \
      invalid command \'
      ERROR: syntax error at or near "INSERT"
      LINE 2: INSERT INTO images VALUES (2,1,'Hub (small)','\\211PNG\\015\...

      I've tried to check images_pgsql.sql file for possible errors but was not able to find any.

        Attachments

          Activity

            People

            Assignee:
            dimir dimir
            Reporter:
            michaelv Michael Veselovski
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: