I'm starting learn Go and SQL. I tryed to make initial migration using golang-migrate in my go project. Database is postgresql This is migration file: CREATE TABLE users ( id serial not null unique, name varchar(255) not null, username varchar(255)…
I am trying to run migrations in my go-fiber rest API using golang-migrate. I added the commands for running the migrations in a makefile. However, when I run make migrateup, I get the following error: migrate -path database/postgres/migrations -database "postgresql://postgres:postgres@localhost:5400/property?sslmode=disable"…
I am setting up a local Postgres database on Docker with the postgres:14-alpine image, and running database migrations on it with golang-migrate, when I got the following error message after running the migrate tool: error: pq: role "root" does not…