connecting postgresql and codeigniter

Question

I'm new using postgresql and I've been using Codeigniter for a year.

I have a small postgresql database and I wanna call it from Codeigniter.

In my database.php file I have this setup:

$active_group = 'default';
$query_builder = TRUE;

$db['default'] = array(
'dsn'   => 'pgsql:host=localhost;port=5432;dbname=test;user=postgres;password=aPass',
// 'dsn'    => '',
'hostname' => 'localhost',
'username' => 'postgres',
'password' => 'aPass',
'database' => 'test',
'dbdriver' => '',
'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
  // 'port' => '5432'
);

In a controller I have this function:

public function dbtest(){

    $this->load->database();

    $feeds = $this->db->get('vts_feeds');
    echo $feeds;die();
}

The result I'm getting is:

An Error Was Encountered
You have not selected a database type to connect to.

Why is it not working?

Stack Programmer · Accepted Answer · 2018-11-24 16:00:44Z

13

Try to set,

dbdriver - The database type. ie: mysql, postgres, odbc, etc. Must be specified in lower case.

More Info: https://www.codeigniter.com/user_guide/database/configuration.html

EDIT: Try this config for PDO in postgres

$db['default']['hostname'] = 'pgsql:host=localhost;dbname=yourdb'; //set host
$db['default']['username'] = 'your username'; //set username
$db['default']['password'] = 'your password'; //set password
$db['default']['database'] = 'your database'; //set databse
$db['default']['dbdriver'] = 'pdo'; //set driver here

edited Nov 24, 2018 at 16:00

Stack Programmer

6796 silver badges18 bronze badges

answered Apr 14, 2015 at 15:07

A l w a y s S u n n y

38.8k9 gold badges68 silver badges120 bronze badges

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

2 Comments

Limon Over a year ago

thx! I had to put pdo in order to work with the config I got. Do you know why does it not work if I put dbdriver = postgres, and just put dsn to blank?

A l w a y s S u n n y Over a year ago

@Limon See my Edited answer, this might help you, Best of luck

Mike Miller · Accepted Answer · 2015-04-15 08:32:17Z

4

Remove the 'dsn' string and change to 'dbdriver' => 'postgre' in the config array.

Despite the CI docs stating the value should be 'postgres' if you check the directory and file names in system>database>drivers the folder is actually called 'postgre', the file name 'postgre_driver.php' and the class 'CI_DB_postgre_driver' so we can assume the docs are wrong here. Weird this hasnt raised its ugly head before

edited Apr 15, 2015 at 8:32

answered Apr 14, 2015 at 15:35

Mike Miller

3,1273 gold badges27 silver badges32 bronze badges

5 Comments

Limon Over a year ago

it says "invalid DB driver". I left dsn in blank and changed dbdriver to "postgres"

Mike Miller Over a year ago

Hmm strange. Do you have the driver file in the system database folder? This should just try to load the CI_postgres_db_driver file

Mike Miller Over a year ago

Looking at the file structure it looks like the right driver value is 'postgre' which is weird as the CI docs definitely say 'postgres'. Try without the 's' and see if that helps - I updated my answer

Limon Over a year ago

yes, you are right. In CI docs there's a mistake, it is postgre and not postgres.

Limon Over a year ago

I upgraded your answer but I had used first the solution given by @BunnySunny

Tunaki · Accepted Answer · 2016-10-23 23:23:23Z

3

I just did it right now. You just leave :

$db['default']['dsn'] = '';

And set:

$db['default']['dbdriver'] = 'postgre';

edited Oct 23, 2016 at 23:23

Tunaki

138k46 gold badges370 silver badges443 bronze badges

answered Oct 23, 2016 at 23:20

Coordinate35

311 bronze badge

Comments

Kurt Van den Branden · Accepted Answer · 2016-10-05 12:53:37Z

1

In the file database.php where it reads:

'dbdriver' => ' ',

Put the following argument:

'dbdriver' => 'pgsql',

edited Oct 5, 2016 at 12:53

Kurt Van den Branden

13.2k10 gold badges83 silver badges92 bronze badges

answered Oct 5, 2016 at 11:42

Fábio Mendonça

891 silver badge2 bronze badges

1 Comment

M. Paul Over a year ago

for me it says "Invalid DB driver". My OS is cent os.

Kamran · Accepted Answer · 2015-04-14 18:21:17Z

0

I had the same problem. Try these steps

don't remove dsn string add port=>5432 to your config array
set dbdriver to 'dbdriver' => 'postgres'
check your php.ini file if postgre extension is enabled or not extension=php_pdo_pgsql.dll

answered Apr 14, 2015 at 18:21

Kamran

2,7412 gold badges19 silver badges24 bronze badges

1 Comment

Limon Over a year ago

the extension was already enabled. I have tried this way too but it's only working with dbdriver=> pdo and the dsn I mentioned

Dejan Dozet · Accepted Answer · 2021-04-03 13:44:01Z

-1

Why don't you create a user in psql by using linux terminal then grant all access to this user? And then change the username and password at config database with that one.

edited Apr 3, 2021 at 13:44

Dejan Dozet

1,07712 silver badges35 bronze badges

answered Apr 3, 2021 at 11:57

Asep.Ridwan

13 bronze badges

1 Comment

dehart Over a year ago

Please use the comment section for follow up questions and note that this question has already been answered

Collectives™ on Stack Overflow

connecting postgresql and codeigniter

6 Answers 6

2 Comments

5 Comments

Comments

1 Comment

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

2 Comments

5 Comments

Comments

1 Comment

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related