KnowGate Open Source CRM
es en

Setup and configuration on PostgreSQL

Setup of PostgreSQL 8.4 on CentOS 6

Logged in as root execute from the command line:

# yum install postgresql84 postgresql84-server postgresql84-contrib
# service postgresql initdb
# service postgresql start
# su postgres
# createdb -E UNICODE hipergate7
# createuser knowgate
# grant all on database hipergate7 to knowgate
# psql hipergate7
hipergate7=# CREATE LANGUAGE plpgsql

Additional notes about configuration of PostgreSQL

PostgreSQL must be listening TCP/IP requests. For enabling TCP/IP edit postgresql.conf file and add:
tcpip_socket = true
virtual_host = ''
port = 5432

Language plpgsql must be installed before performing the initial creation of the data model with the Setup Wizard.
For checking whther plpgsql is installed execute: select lanname from pg_language

The database must be created with UNICODE character set, otherwise the error "SQLException 42P01 ERROR: relation k_x_app_workarea does not exist will be raised".

hipergate © 2003-2013 KnowGate. Some rights reserved [] [] [Valid XHTML 1.0] [Valid CSS 3]