golang-migrate unable to find postgres driver

Question

In my internal/platform/database/database.go


import (
    "github.com/golang-migrate/migrate"
    "github.com/jmoiron/sqlx"
    _ "github.com/lib/pq"
)

func RunMigrations() error {
    m, err := migrate.New(
        "file://schema",
        "postgres://postgres:postgres@localhost:5432/postgres?sslmode=disable")
    if err != nil {
        return errors.Wrap(err, "error creating migrations object")
    }

This function is invoked from my cmd/my-api/main.go as follows:


import (
    _ "github.com/golang-migrate/migrate/v4/database/postgres"
    _ "github.com/golang-migrate/migrate/v4/source/file"
    "github.com/jmoiron/sqlx"
    _ "github.com/lib/pq"
    "github.com/myrepo/myproject/internal/platform/database"
)

    // =========================================================================
    // Executing migrations
    if err := database.RunMigrations(); err != nil {
        log.Fatal(err)
    }

Although I am importing postgres driver in both files, _ "github.com/lib/pq"

running the program fails as follows:

error creating migrations object: source driver: unknown driver file (forgotten import?)
exit status 1

Why is that?

pkaramol · Accepted Answer · 2020-03-28 19:20:46Z

7

It seems that golang-migrate needs its own version of the corresponding driver (?)

The following import solved it for me

_ "github.com/golang-migrate/migrate/v4/database/postgres"

answered Mar 28, 2020 at 19:20

pkaramol

19.9k64 gold badges214 silver badges443 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

demirpolatb · Accepted Answer · 2020-04-01 00:20:45Z

1

When you import the following, postgres driver init function triggered and this function register the postgres driver.

_ "github.com/golang-migrate/migrate/v4/database/postgres"

You can inspect this. https://www.calhoun.io/why-we-import-sql-drivers-with-the-blank-identifier/

answered Apr 1, 2020 at 0:20

demirpolatb

1711 silver badge5 bronze badges

Collectives™ on Stack Overflow

golang-migrate unable to find postgres driver

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related