在代码点火器中从mysql迁移到postgresql

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

我试图在codeigniter中从mysql迁移到postgres。我已经更新了我的database.php文件

$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.

每当迁移后进行数据库调用时，我都会得到一个空白页面。没有错误/没有显示日志。我是否还需要在其他任何地方进行更改。任何帮助将受到高度赞赏。

1 个解决方案

#1

Add these settings with postgres

使用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

一些有用的链接

1 个解决方案

#1

更多相关文章

随机推荐