migrate -database postgres://greenlight:xxxxxx@localhost:55433/greenlight?sslmode=disable ?-path ./migrations/ ?up

報錯信息：

error: pq: permission denied for schema public in line 0: CREATE TABLE IF NOT EXISTS "public"."schema_migrations" (version bigint not null primary key, dirty boolean not null)

處理辦法

使用postgres用戶登錄數據庫，執行下面命令：

grant all privileges on database greenlight to greenlight

alter database greenlight owner to greenlight

然后重新執行上面migrate命令，成功執行：

1/u create_movies_table (19.429ms)
2/u add_movies_check_constraints (30.8229ms)