Ad Widget

Collapse

non standard postgresql port

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • techhubhub
    Junior Member
    • Jun 2007
    • 1

    #1

    non standard postgresql port

    Zabbix 1.4 (source distribution) + Postgresql 8.2.4 + Linux 2.6.x

    It works with pgsql listening on standard port 5432, but...I need it to listen on a different port (2 pgsql instances)


    Combinations that doesn't work
    • DBport on config file
    • DBport on config file after patching db.c to use port parameter (src/libs/zbxdb/db.c:131)
    • patching db.c to use PQconnectdb (hardcoded connection string) instead of PQsetdbLogin


    The only combination that work
    • PGPORT environment variable and db.c untouched


    It should work setting DBport in config file or documented some where (I didn't find related bugs, known issues, etc.)

    regards
Working...