How to configure Symfony 4 with PostgreSQL on Ubuntu or Mac OS
Install PostgreSQL on Ubuntu
Easily install PostgreSQL from the command line with apt-get.
sudo apt-get update sudo apt-get install postgresql postgresql-contrib
Install PostgreSQL on Mac
On Mac OS, go to your terminal and use brew as shown here.
brew install postgresql postgres -V to see the version
Use composer to install Doctrine
If Doctrine is not already installed, then from the command line in your Symfony 4 project directory, use composer to require doctrine.
composer require doctrine/doctrine-bundle
Change the dbal values as shown below.
... doctrine: dbal: driver: 'pdo_pgsql' charset: utf8 ...
Edit the .env file.
PostgreSQL may create a user matching the user you logged in as. You will need to change the db_user and password to whatever is appropriate. Replace the mysql settings with the PostgreSQL settings as shown below:
... DATABASE_URL=pgsql://db_user:firstname.lastname@example.org:5432/db_name ...
Now you can use the command line to create the database!
php bin/console doctrine:database:create