codeigniter connect with postgresql database

Question

The code is connect but the database group is invalid i.e. the code doesnt connect with the database because the setting in database.php file is invalid. where do we look for the error and how to resolve this.

You have specified an invalid database connection group (db) in your config/database.php file.

This file show error but not specified to where is error

config/database.php code below: 


$db['default'] = array(
    'dsn'   => 'pgsql:host=localhost;port=5432;dbname=success_story',
    'hostname' => 'localhost',
    'username' => 'puneetchhabra',
    'password' => 'shambhu',
    'database' => 'success_story',
    'dbdriver' => 'mysqli',
    '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
);

The database.php file code is show what seems to be the error.

browser has this error unable to connect.

Message: pg_connect(): Unable to connect to PostgreSQL server: missing "=" `after "localhost" in connection info string`

Be kind and suggest.

Thanks.

What's your $active_group ? in your database.php you should declare $active_group = 'default'; — Atural
– Atural, Commented Oct 7, 2019 at 10:29
i don't think so - because Codeigniter tells you it is $active_group = 'db'; (according to your error message) — Atural
– Atural, Commented Oct 7, 2019 at 10:40
i didnt quite get you you mean instead of 'default' i write 'db'. is that what you mean ? — Prabhakar Siddhant
– Prabhakar Siddhant, Commented Oct 7, 2019 at 10:52

Abdulla Nilam · Accepted Answer · 2019-10-07 10:54:39Z

1

try this

$db['default'] = array(
    'dsn'   => 'localhost',
    'hostname' => 'localhost',
    'username' => 'puneetchhabra',
    'password' => 'shambhu',
    'database' => 'success_story',
    'dbdriver' => 'postgre', # or PDO
    'port' => '' #ex 5433
);

make sure

You can connect outside the application (pgadmin)
In php.ini enable extenxtion php_pdo_pgsql (for pdo) and php_pgsql(for postgre).

answered Oct 7, 2019 at 10:54

Abdulla Nilam

39.6k18 gold badges85 silver badges114 bronze badges

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

4 Comments

Prabhakar Siddhant Over a year ago

the error still remains i'll update the php.ini and enable extension

Abdulla Nilam Over a year ago

restart the xamp/LAMP

Prabhakar Siddhant Over a year ago

hello again, so the code for the following extension is enable; conf/php.ini. where does the problem exist ?

Prabhakar Siddhant Over a year ago

so i narrowed it down to the error is Message: pg_connect(): Unable to connect to PostgreSQL server: missing "=" after "localhost" in connection info string

Collectives™ on Stack Overflow

codeigniter connect with postgresql database

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related