connecting postgresql codeigniter

Question

I'm trying to connect a postgres db but I get this error

my database.php file I have the default connection too add

$db['newdb'] = array(
        'dsn'   => 'pgsql:host=192.xxx.x.xxx;port=5432;dbname=dbname',
        'hostname' => 'localhost',
        'username' => 'username',
        'password' => 'password',
        'database' => 'dbname',
        'dbdriver' => 'pgsql',
        'dbprefix' => '',
        'pconnect' => FALSE,
        'db_debug' => (ENVIRONMENT !== 'production'),
        'cache_on' => FALSE,
        'cachedir' => '',
        'char_set' => 'utf8',
        'dbcollat' => 'utf8_general_ci',
        'swap_pre' => '',
        'encrypt' => FALSE,
        'compress' => FALSE,
        'stricton' => FALSE,
        'failover' => array(),
        'save_queries' => TRUE
    );

here my modal

<?php
class Model extends CI_Model {

 private $db_b;

 function __construct(){
  $this->db_b = $this->load->database('newdb', TRUE);
 }


 public function getData()
 {

   $this->db_b->order_by('ad_reference_id', 'asc');
   $query = $this->db_b->get('table');
   if ($query->num_rows() > 0) {
     return $query->result();
   } else {
     return false;
   }
 }
}

I got this ERROR An Error Was Encountered

Invalid DB driver

Why is it not working? :(

change 'dbdriver' => 'pgsql' to 'dbdriver' => 'pdo'

Abhijit Mali
– Abhijit Mali

2018-06-21 18:01:50 +00:00
Commented Jun 21, 2018 at 18:01 — Abhijit Mali
– Abhijit Mali, Commented Jun 21, 2018 at 18:01

DFriend · Accepted Answer · 2018-06-21 21:10:18Z

1

You have designated a driver that does not exist with this

'dbdriver' => 'pgsql',

I think what you want is

'dbdriver' => 'postgre',

Edit: Checking PHP configuration

Create a controller called Info.php Here's the code for it.

<?php
defined('BASEPATH') OR exit('No direct script access allowed');

class Info extends CI_Controller
{
    public function index()
    {
        phpinfo();
    }
}

Direct the browser to yoursite.com/info and search the resulting page for postgres.

edited Jun 21, 2018 at 21:10

answered Jun 21, 2018 at 18:03

DFriend

8,9741 gold badge16 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

MoteCL Over a year ago

Type: Error Message: Call to undefined function pg_connect() Filename: /var/www/html/test/system/database/drivers/postgre/postgre_driver.php Line Number: 154

DFriend Over a year ago

Well that is weird because pg_connect() is a PHP function. You certain that your PHP has PostgreSQL installed?

MoteCL Over a year ago

how can I check that? I'm on linux Mint

DFriend Over a year ago

See the added info in the answer.

MoteCL Over a year ago

could affect in the server they have php 5.0 and Im working with codeigniter 3.1.9

|

Collectives™ on Stack Overflow

connecting postgresql codeigniter

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related