I am having connection issues when I try to connect my goLang GORM service to a Docker Postgress container. I believe the problem is my golang code at the bottom at the connection string.
docker-compose up
Recreating postgress_postgre_1 ... done
Attaching to postgres
postgres | 2018-12-11 21:08:48.283 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432
postgres | 2018-12-11 21:08:48.283 UTC [1] LOG: listening on IPv6 address "::", port 5432
postgres | 2018-12-11 21:08:48.291 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
postgres | 2018-12-11 21:08:48.316 UTC [20] LOG: database system was shut down at 2018-12-11 21:08:44 UTC
postgres | 2018-12-11 21:08:48.328 UTC [1] LOG: database system is ready to accept connections
=== when I run the golang I get... panic: failed to connect database
=============== docker-compose.yml
version: '3.6'
services:
postgre:
image: postgres:11.1-alpine
ports:
- '5432:5432'
network_mode: bridge
container_name: postgres
environment:
POSTGRES_USER: 'user'
POSTGRES_PASSWORD: 'password'
POSTGRESS_DB: 'db_amex01'
volumes:
- ./init:/docker-entrypoint-initdb.d/
==== main.go
package main
import (
"fmt"
"log"
"net/http"
"github.com/gorilla/mux"
"github.com/jinzhu/gorm"
// _ "github.com/jinzhu/gorm/dialects/sqlite"
_ "github.com/jinzhu/gorm/dialects/postgres"
)
// _ "github.com/jinzhu/gorm/blob/master/dialects/postgres"
type ToDo struct {
gorm.Model
ID int `json:"id"`
TASK_STRING string `json:"task_string"`
DONE bool `json:"done"`
}
var db *gorm.DB
var err error
func main() {
const (
host = "localhost"
port = 5432
user = "postgres"
password = "password"
dbname = "db_amex01"
)
// this is the problem I believe I am having...
db, err := gorm.Open("postgres", "host='postgres' port=5432 user=user dbname='db_amex01' password='password'")
defer db.Close()
if err != nil {
panic("failed to connect database")
}
defer db.Close()