Live Helper Chat also supports PostgreSQL here is instructions how to switch from MySQL to PostgreSQL
Instruction
- Download postgresql branch from github
- Change these settings in settings/settings.ini.php file
- Change secret hash value to 'secrethash' => '7702888d11',
- In 'db' section add 'search_path' => 'public',
- Change other database settings. It should look like for example
- 'host' => 'localhost',
- 'user' => '<username>',
- 'password' => '<username>',
- 'database' => 'lhc_install',
- 'search_path' => 'public',
- 'port' => 5432,
- Change installed value to true 'installed' => true,
- Make sure php can write to these folders. If what just chmod them
- cache/
- settings/settings.ini.php
- var/userphoto
- var/storage
- Like PostgreSQL version of Live Helper Chat does not have a install script. Import default database from doc/postgresql/postgreql.sql
- Example command psql -h localhost -d lhc_install -U postgres -f postgresql.sql
- Enter site url index.php/site_admin/ login window should be present
- Login: admin
- Pass: demo
- If you have logged succesfully again edit settings/settings.ini.php file and enable cache
- 'templatecache' => true,
- 'templatecompile' => true,
- 'modulecompile' => true,
- While being logged change secret hash value to any random string and change password in back office.
- Have fun! that's all :)
Important
At this stage PostgreSQL support is experimental and need more testing. After few weeks it should be stable. Please test it if you can.