dbmate with postgres - Error: pq: must be owner of extension uuid-ossp about dbmate HOT 4 CLOSED

You might want to put

create extension "uuid-ossp";

at the top of _init.sql. It's not a dbmate issue - you're likely trying to create uuids without installing the necessary postgres extension.

from dbmate.

@wkalt Yes, I tried it already, added to template1 before I'm creating the new db.
create extension if not exists uuid-ossp with schema public;
It does not work. And got the same error. Who is pq?

from dbmate.

It sounds like for whatever reason the user you're using to postgres doesn't have permission to use that extension. This isn't a dbmate issue, I expect you will see the same error if you try running that same command using psql.

I recommend trying it with the default/root user created by RDS when you set up the database. If that doesn't work, try creating a completely new RDS instance as a troubleshooting step.

from dbmate.

ALTER EXTENSION postgis UPDATE;
ALTER EXTENSION postgis_topology UPDATE;

-- yes run it twice
SELECT postgis_extensions_upgrade();
SELECT postgis_extensions_upgrade();

from dbmate.