Connecting CakePHP 4.1.1 to Postgresql

So I assume you already installed your own fresh CakePHP 4.1.1. Here's mine:

Next, create Db in postgres like this:

Here's my postgres server connection properties:

To connect our db to cakephp 4.1.1 we need to set 2 items:

1. Driver

2. Default datasources properties.

Here's the screen shoot:

1. Driver:

2. Datasource

And if we run the server:

and then opening theeee http://localhost:9999/

Yep yep yep... :D

MySql cheat sheet