Installing with PostgreSQL. Errors relating to citext and or Fluent Migrator

If you are having problems installing with a PostgreSQL database you may need to run this SQL command on your database first.

CREATE EXTENSION IF NOT EXISTS citext WITH SCHEMA public;

I had to do this to install with the latest Nop version 4.60.2 and PostgreSQL 12.

The citext extension allows you to define insensitive-case columns which is necessary for Nop to run.

For more info read:
https://nandovieira.com/using-insensitive-case-columns-in-postgresql-with-citext

Yes, the citext extension is required. nopCommerce installs it (if not exist) on the database initialization.