i’m now having trouble connecting to my local post...
# orm-helpi
immediato
02/21/2019, 3:06 PMi’m now having trouble connecting to my local postgres db. i’m trying to use the Postico app on MacOS. the docker container is running but when i try to connect i get an issue that the connection was refused
h
Harshit
02/21/2019, 3:07 PMcan you share the docker-compose file?
i
immediato
02/21/2019, 3:07 PMsure what’s the best way? pastebin?
h
Harshit
02/21/2019, 3:07 PMjust paste here
i
immediato
02/21/2019, 3:07 PMversion: ‘3’
services:
prisma:
image: prismagraphql/prisma:1.27
restart: always
ports:
- ‘4466:4466’
environment:
PRISMA_CONFIG: |
port: 4466
# uncomment the next line and provide the env var PRISMA_MANAGEMENT_API_SECRET=my-secret to activate cluster security
# managementApiSecret: my-secret
databases:
default:
connector: postgres
host: postgres
user: prisma
password: prisma
rawAccess: true
port: 5432
migrations: true
postgres:
image: postgres
restart: always
environment:
POSTGRES_USER: prisma
POSTGRES_PASSWORD: prisma
volumes:
- postgres:/var/lib/postgresql/data
volumes:
postgres:
h
Harshit
02/21/2019, 3:08 PMYou will require to map the postgres instance to a port
i
immediato
02/21/2019, 3:09 PMi do that in the compose file or somewhere else?
h
Harshit
02/21/2019, 3:09 PMyes in docker compose file
Harshit
02/21/2019, 3:09 PMlet me do that paste the file here
Harshit
02/21/2019, 3:09 PMAre you running a existing postgres server in your machine ,then I will mapit to some other port(means not 5432)
i
immediato
02/21/2019, 3:10 PMi’m not sure if i’m running another server
immediato
02/21/2019, 3:10 PMeasy way to tell?
immediato
02/21/2019, 3:10 PMthese are the only two docker containers i have running at the moment so i’m not sure if that helps
h
Harshit
02/21/2019, 3:10 PMlsof -i :5432
Paste the output of this command if you are on a mac
i
immediato
02/21/2019, 3:12 PMlsof: WARNING: can’t stat() apfs file system /Volumes/com.apple.TimeMachine.localsnapshots/Backups.backupdb/Marc’s MacBook Pro/2019-02-14-120423/Macintosh HD
Output information may be incomplete.
assuming “dev=31000004” from mount table
immediato
02/21/2019, 3:12 PMnot sure if that is related or not but that’s what i get when i type that command
h
Harshit
02/21/2019, 3:12 PMok its fine
Harshit
02/21/2019, 3:13 PMpaste this now in docker-compose
Harshit
02/21/2019, 3:13 PM Copy code
version: '3'
services:
prisma:
image: prismagraphql/prisma:1.27
restart: always
ports:
- '4466:4466'
environment:
PRISMA_CONFIG: |
port: 4466
# uncomment the next line and provide the env var PRISMA_MANAGEMENT_API_SECRET=my-secret to activate cluster security
# managementApiSecret: my-secret
databases:
default:
connector: postgres
host: postgres
user: prisma
password: prisma
rawAccess: true
port: 5432
migrations: true
postgres:
image: postgres
restart: always
ports:
- '5432:5432'
environment:
POSTGRES_USER: prisma
POSTGRES_PASSWORD: prisma
volumes:
- postgres:/var/lib/postgresql/data
volumes:
postgres:Harshit
02/21/2019, 3:13 PMand restart the container
Harshit
02/21/2019, 3:13 PMthen you can connect to it on localhost:5432
Harshit
02/21/2019, 3:14 PMusername and password is prisma
i
immediato
02/21/2019, 3:15 PMyes! thank you so much for your help
immediato
02/21/2019, 3:15 PMon this and the other issue