1. Install on OSX with Homebrew
    • brew install postgresql
    • postgres -V to see the version
  2. Add doctrine and doctrine migration
    • composer require doctrine/doctrine-bundle
  3. Edit config/doctrine.yaml and replace the default mysql settings in doctrine/dbal section as follows
    doctrine:
    dbal:
        driver: 'pdo_pgsql'
        charset: utf8
    
  4. Edit DATABASE_URL in .env and replace the default mysql settings as follows:
    • start with pgsql driver
    • use port 5432
    • change the database user to one which exists (tip: postgress will create a user matching your logged in user)
  5. Create the database bin/console doctrine:database:create