Hello #pleroma admins.... Just ran into this one when running ecto.migrate

permissions issue about postgresql extension.

assuming you didn't change defaults. here is your fix:

sudo -u postgres psql -d pleroma_dev -c 'CREATE EXTENSION IF NOT EXISTS "uuid-ossp";'

You can also get manual:
su postgres
psql pleroma_dev
CREATE EXTENSION IF NOT EXISTS "uuid-ossp";