Migrating from mysql to postgresql in code igniter

Question

I am trying to migrate from mysql to postgres in codeigniter. I have updated my database.php file

$db['default']['hostname'] = 'pgsql:host=localhost;dbname=mydb';

$db['default']['username'] = 'postgres';

$db['default']['password'] = 'myPass23';

$db['default']['database'] = 'mydb';



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

I am getting a blank page whenever db call is being made after the migration. No error/No logs are being shown. Do I need to make the changes anywhere else too. Any help will be highly appreciated.

you have missed $ in first line. Is it copy paste mistake?? — Niranjan N Raju
– Niranjan N Raju, Commented Nov 4, 2015 at 9:07

Abdulla Nilam · Accepted Answer · 2015-11-04 11:38:34Z

1

Add these settings with postgres

$db['default']['hostname'] = 'localhost';
$db['default']['username'] = 'postgres'; # Mysql name
$db['default']['password'] = 'myPass23'; # Mysql password
$db['default']['database'] = 'mydb'; # databse name
$db['default']['dbdriver'] = 'postgre'; # chnage this

Some Useful link

answered Nov 4, 2015 at 11:38

Abdulla Nilam

39.8k18 gold badges85 silver badges115 bronze badges

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

Collectives™ on Stack Overflow

Migrating from mysql to postgresql in code igniter

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related