PostgreSQL support

Last modification: 2014-02-08 21:01:01

Live Helper Chat also supports PostgreSQL here is instructions how to switch from MySQL to PostgreSQL

Instruction

  1. Download postgresql branch from github
  2. Change these settings in settings/settings.ini.php file
    1. Change secret hash value to 'secrethash' => '7702888d11',
    2. In 'db' section add 'search_path' => 'public',
    3. Change other database settings. It should look like for example
      1. 'host' => 'localhost',
      2. 'user' => '<username>',
      3. 'password' => '<username>',
      4. 'database' => 'lhc_install',
      5. 'search_path' => 'public',
      6. 'port' => 5432,
    4. Change installed value to true 'installed' => true,
  3. Make sure php can write to these folders. If what just chmod them
    1. cache/
    2. settings/settings.ini.php
    3. var/userphoto
    4. var/storage
  4. Like PostgreSQL version of Live Helper Chat does not have a install script. Import default database from doc/postgresql/postgreql.sql
    1. Example command psql -h localhost -d lhc_install -U postgres -f postgresql.sql
  5. Enter site url index.php/site_admin/ login window should be present
    1. Login: admin
    2. Pass: demo
  6. If you have logged succesfully again edit settings/settings.ini.php file and enable cache
    1. 'templatecache' => true,
    2. 'templatecompile' => true,
    3. 'modulecompile' => true,
  7. While being logged change secret hash value to any random string and change password in back office.
  8. 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.

Support project

Developing application takes a lot of time. You can support application by donating. There is no company behind this application and it takes away my free time. Every donation matters and does not matter how small it is!


Paypal, one time donation
Monthly donation
Bitcoin
bc1q6gkl2hcwtn2g26em6axc7jehmn2hd9x8g7nzx9

USDT (Ethereum network)
0x45b92C4aa29EFD3252fD04fcDDe3e6Ef8b399D75