Welcome Guest, Not a member yet? Register   Sign In
Problem connect to PostgreSQL
#1
Smile 

Hi. Smile
I have two databases to connect to CI 3, they are the MySQL and PostgreSQL. MySQL is connected fine, but not for PostgreSQL. And also I edited the php.ini so that the php_pgsql.dll and php_pdo_mysql.dll executed.

Local server: Xampp/Wampserver

For detail configuring the connection:
$db['postgre_terunasi'] = array(
'dsn' => 'pgsql:host=127.0.0.1;port=5432;dbname=terunasi;user=terunasi;password=terunasi1',
//'dsn' => '',
'hostname' => '127.0.0.1',
'username' => 'terunasi',
'password' => 'terunasi1',
'database' => 'terunasi',
'dbdriver' => 'postgre',
'dbprefix' => '',
'pconnect' => FALSE,
'db_debug' => TRUE,
'cache_on' => FALSE,
'cachedir' => '',
'char_set' => 'utf8',
'dbcollat' => 'utf8_general_ci',
'swap_pre' => '',
'encrypt' => FALSE,
'compress' => FALSE,
'stricton' => FALSE,
'failover' => array(),
'save_queries' => TRUE
);

Fatal error: Call to undefined function pg_connect() in C:\Lab~ Fatih Kodin\www\terunasi\system\database\drivers\postgre\postgre_driver.php on line 154

Any solution?
Thank you Big Grin
help please  Big Grin
Reply




Theme © iAndrew 2016 - Forum software by © MyBB