Docker – How can run the psql command in the postgres container?

by 
docker exec -it yiialkalmi_postgres_1 psql -U project -W project

Some explanation

  • docker exec -it
    The command to run a command to a running container. The it flags open an interactive tty. Basically it will cause to attach to the terminal. If you wanted to open the bash terminal you can do this

docker exec -it yiialkalmi_postgres_1 bash

  • yiialkalmi_postgres_1
    The container name (you could use the container id instead, which in your case would be 40e39bd0329a )

  • psql -U project -W project
    The command to execute to the running container

  • U user

  • W Tell psql that the user needs to be prompted for the password at connection time. This parameter is optional. Without this parameter, there is an extra connection attempt which will usually find out that a password is needed, see the PostgreSQL docs.

  • project the database you want to connect to. There is no need for the -d parameter to mark it as the dbname when it is the first non-option argument, see the docs: -d “is equivalent to specifying dbname as the first non-option argument on the command line.”

These are specified by you here

environment:
    POSTGRES_DB: project
    POSTGRES_USER: project
    POSTGRES_PASSWORD: project

More Related Contents:

  1. How to persist data in a dockerized postgres database using volumes
  2. Changing a postgres containers server port in Docker Compose
  3. Spring Docker container cannot access Postgres Docker container
  4. Connecting to Postgresql in a docker container from outside
  5. Docker Compose + Spring Boot + Postgres connection
  6. Django connection to postgres by docker-compose
  7. docker postgres pgadmin local connection
  8. How to customize the configuration file of the official PostgreSQL Docker image?
  9. Docker wait for postgresql to be running
  10. Docker – Postgres and pgAdmin 4 : Connection refused
  11. Insert, on duplicate update in PostgreSQL?
  12. How does the search_path influence identifier resolution and the “current schema”
  13. How do you find the row count for all your tables in Postgres
  14. Using Docker-Compose, how to execute multiple commands
  15. Run batch file with psql command without password
  16. Postgresql: Conditionally unique constraint
  17. How do you use variables in a simple PostgreSQL script?
  18. How to switch databases in psql?
  19. Postgresql: Scripting psql execution with password
  20. Flask CLI throws ‘OSError: [Errno 8] Exec format error’ when run through docker-compose
  21. Does a Postgres UNIQUE constraint imply an index?
  22. SELECT raises exception in PL/pgSQL function
  23. Dynamically generate columns for crosstab in PostgreSQL
  24. postgres autoincrement not updated on explicit id inserts
  25. Retrieving Comments from a PostgreSQL DB
  26. Orbeon Forms Postgres DB connection
  27. How to delete an enum type value in postgres?
  28. Why unsigned integer is not available in PostgreSQL?
  29. How to install extension for php via docker-php-ext-install?
  30. now() default values are all showing same timestamp

Leave a Comment