pgx not following intended import behaviour

[krishi-saripalli]

Describe the Bug This is a follow up to issue #563

Despite following the guidlines about how to import drivers from database, I seem to be hitting the same problem with an unknown import error:

database driver: unknown driver pgx (forgotten import?)

I've also run the neccesary go get command with the pgx tag go install -tags 'pgx' github.com/golang-migrate/migrate/v4/cmd/migrate@latest

"github.com/golang-migrate/migrate/v4"
    _ "github.com/golang-migrate/migrate/v4/database/pgx/v5"
    _ "github.com/golang-migrate/migrate/v4/source/file"

//more imports  
)

func main() {
    ctx := context.Background()
    port := ":8080" // Define the port as a variable for reuse
    lis, err := net.Listen("tcp", port)
    if err != nil {
        log.Fatalf("Failed to listen: %v", err)
    }
    //open db connection
    connStr := GetDbString()
    conn, err := pgx.Connect(ctx, connStr)
    if err != nil {
        log.Fatalf("Failed to connect to Postgres DB: %v", err)
    }
    log.Print("Successfully connected to %f", connStr)
    defer conn.Close(ctx)
    queries := db.New(conn)

    //Create server and register services
    grpcServer := grpc.NewServer()

    // Run migrations
    m, err := migrate.New(
        "file:///postgres/migrations",
        "pgx://test_db_user:test_db_password@db:5432/my_test_db")
    if err != nil {
        log.Fatalf("Migration creation failed: %v", err)  <------ failing here
    }
    if err := m.Up(); err != nil {
        if err != migrate.ErrNoChange {
            log.Fatalf("Migration failed: %v", err)
        }
    }
    log.Println("Migration completed successfully")

Steps to Reproduce Steps to reproduce the behavior:

1. My migrations look like '...'
2. I ran migrate with the following options '....'
3. See error

Expected Behavior I would expect a succesful migration

Loaded Database Drivers pgx

Go Version go 1.21 linux/amd64

[lao-tseu-is-alive]

I did have the same issue... I found that because of --> https://github.com/golang-migrate/migrate/blob/master/database/pgx/v5/pgx.go#L30

You need to use pgx5 in your dsn like this :

m, err := migrate.New(
        "file:///postgres/migrations",
        "pgx5://test_db_user:test_db_password@db:5432/my_test_db")

hope it can help you or someone else