How to config postgresql with php to run TomatoCMS 2.0.5

From TomatoCMS Documentation

Jump to: navigation, search

At version 2.0.5, TomatoCMS support more than one database include postgreSQL.

Config postgresql with php

At here, we introduce you to config postgresql with php to run TomatoCMS 2.0.5
First, open php.ini file to modify as 

[PHP_PGSQL]
extension=php_pgsql.dll

Let's restart your apache.
Then, copy libeay32.dll, libpg.dll, ssleay32.dll files in php folder to system32 folder of window.
That all actions you need to do to config postgresql with php.

Config to run TomatoCMS 2.0.5

Config app.ini file as following to run TomatoCMS 2.0.5 with postgreSQL database 

[db]
adapter = "pgsql"
prefix = ""
slave.server2.host = "localhost"
slave.server2.port = "3307"
slave.server2.dbname = "tomatocms"
slave.server2.username = "tomato"
slave.server2.password = "123456"
slave.server2.charset = "utf8"
master.server1.host = "localhost"
master.server1.port = "3307"
master.server1.dbname = "tomatocms"
master.server1.username = "tomato"
master.server1.password = "123456"
master.server1.charset = "utf8"

Then, run tomatocms_sample_db_postgre.sql file to import sample data for postgreSQL database.
Now, you had a website run with postgreSQL database.

Retrieved from "http://docs.tomatocms.com/index.php/How_to_config_postgresql_with_php_to_run_TomatoCMS_2.0.5"
Personal tools