If you're encountering an error like: Error: postgres: querying system variables: pq: SSL is not enabled on the server

[letavocado]

If you're encountering an error like:

Error: postgres: querying system variables: pq: SSL is not enabled on the server

use

locals {
  envfile = {
    for line in split("\n", file(var.envfile)) :
    trimspace(slice(split("=", line), 0, 1)[0]) => trimspace(join("=", slice(split("=", line), 1, length(split("=", line)))))
    if !startswith(trimspace(line), "#") && length(split("=", line)) > 1
  }
}

in your atlas.hcl

full example

variable "envfile" {
  type    = string
  default = "./.env.local"
}

locals {
  envfile = {
    for line in split("\n", file(var.envfile)) :
    trimspace(slice(split("=", line), 0, 1)[0]) => trimspace(join("=", slice(split("=", line), 1, length(split("=", line)))))
    if !startswith(trimspace(line), "#") && length(split("=", line)) > 1
  }
}

env "local" {
  name = atlas.env
  src = "file://data/db/schema.sql"

  url  = local.envfile["DATABASE_URL"]
  dev = "docker://postgres/16/dev"

  migration {
    dir = "file://data/db/migrations"
  }
}

[a8m]

The default sslmode is required, but it looks like you're running a (local?) database that has SSL disabled. In this case, you should explicitly set sslmode=disable in the connection URL. See this link for more information.

[letavocado]

Hey @a8m! Thank you for useful link. Yes I know, but in this doc https://atlasgo.io/faq/dotenv-files we see this example:

locals {
    envfile = {
        for line in split("\n", file(var.envfile)): split("=", line)[0] => regex("=(.*)", line)[0]
        if !startswith(line, "#") && length(split("=", line)) > 1
    }
}

and this works for simple KEY=VALUE pairs but fails when a value contains an = itself, like in query strings or URLs

so I provided solution that supports query strings

locals {
  envfile = {
    for line in split("\n", file(var.envfile)) :
    trimspace(slice(split("=", line), 0, 1)[0]) => trimspace(join("=", slice(split("=", line), 1, length(split("=", line)))))
    if !startswith(trimspace(line), "#") && length(split("=", line)) > 1
  }
}