Cant connect from workspace by psql

[LordJohn42]

Info:

• Docker version: 18.09.6, build 481bc77
• Laradock commit: 04c6aaf
• System info (Mac, PC, Linux): Linux
• System info disto/version: Ubuntu 16.04 (Digital Ocean droplet)

Issue:

Cant connect to postgres from workspace.

Try command:

psql
## OR
psql -H localhost
## OR
psql -U default


psql: could not connect to server: No such file or directory
	Is the server running locally and accepting
	connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

---

Expected behavior:

Succesful connect to postgres db.

---

Reproduce:

psql

---

This is really simple error. But i dont understand, what im doing wrong.

[DesarrolloJulio]

Hello, I try to log in to psql and send me this message
sudo docker-compose exec postgres psql -U gamest -d gamest
psql: error: could not connect to server: FATAL: role "gamest" does not exist

[shov]

@LordJohn42 from inside of the workspace container you should connect not to localhost but to postgres

• Make sure you workspace and postgres are both running docker-compose ps
• Go into the workspace docker-compose exec workspace bash
• Connect psql -U default -h postgres -p 5432 default
  ps check the creds in your .env and the port in output of ps

[stale]

Hi 👋 this issue has been automatically marked as stale 📌 because it has not had recent activity 😴. It will be closed if no further activity occurs. Thank you for your contributions ❤️.

[LordJohn42]

@shov Thank you.

[parmonov98]

getting this error after psql -U default -h postgres -p 5432 default inside workspace container
psql: error: FATAL: password authentication failed for user "default"

POSTGRES_VERSION=alpine
POSTGRES_DB=default
POSTGRES_USER=default
POSTGRES_PASSWORD=secret
POSTGRES_PORT=5432