Unable to connect to the database. (postgres)

Dear Friends,
I try to do your code with postgres. But when I click upload button i got error as "CodeIgniter\Database\Exceptions\DatabaseException #8 Unable to connect to the database."

My connection details on localhost is:

PHP Code:

public $default = [
'DSN' => '',
'hostname' => 'localhost',
'username' => 'postgres',
'password' => '123',
'database' => 'demo',
'DBDriver' => 'Postgre',
'DBPrefix' => '',
'pConnect' => false,
'DBDebug' => (ENVIRONMENT !== 'production'),
'cacheOn' => false,
'cacheDir' => '',
'charset' => 'utf8',
'DBCollat' => 'utf8_general_ci',
'swapPre' => '',
'encrypt' => false,
'compress' => false,
'strictOn' => false,
'failover' => [],
'port' => 5432,
]; 


Please advise .. I am new in CI 4.0.4

I run the code using spark (php spark serve)

Waiting fast reply ...
Thanks
Anes P A

Attached Files

Thumbnail(s)
   

Check if the name of the db Driver, table, user and password are correct.

Please post the error message in order to see what's wrong.

If you run it using spark it most likely has a port number also

So it would be 'hostname' = 'localhost:8080' or something like that.

If I run it on my system it is http://localhost:8080

What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )

If you run it using spark it most likely has a port number also

So it would be 'hostname' = 'localhost:8080' or something like that.

If I run it on my system it is http://localhost:8080

I added that 8080 in localhost as

public $default = [
'DSN'      => 'pgsql:host=localhost;port=5432;dbname=demo;user=postgres;password=123',
'hostname' => 'pgsql:host=localhost:8080;dbname=demo',
'username' => 'postgres',
'password' => '123',
'database' => 'demo',
'DBDriver' => 'Postgre',
'DBPrefix' => '',
'pConnect' => false,
'DBDebug'  => (ENVIRONMENT !== 'production'),
'cacheOn'  => false,
'cacheDir' => '',
'charset'  => 'utf8',
'DBCollat' => 'utf8_general_ci',
'swapPre'  => '',
'encrypt'  => false,
'compress' => false,
'strictOn' => false,
'failover' => [],
'port'    => 5432,
];




Still the same Error...

Check if the name of the db Driver, table, user and password are correct.

Please post the error message in order to see what's wrong.

all details are correct...
Got error as

odeIgniter\Database\Exceptions\DatabaseException #8

Unable to connect to the database. 

Did you check to see what your port number was when you started the spark serve?

It shows on screen when you start it, yours maybe different from mine.

What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )