I ran a docker-compose to run Postgres and pgadmin, with the following docker-compose file. I can login to pgadmin but pgadmin cannot connect to the Postgres. However, Postgres is running smoothly and accepting requests. docker-compose.yaml version: "3" services: postgres: image:…
I am not sure as to why I cannot connect my postgres client in my docker container from OUTSIDE my docker container. docker-compose setup db: container_name: postgres-container image: postgres:latest ports: - "5432:5432" environment: - POSTGRES_USER=liondancer - POSTGRES_PASSWORD=postgres volumes: - ../data/postgres:/var/lib/postgresql/data…
I had exported a bunch of tables (>30) as CSV files from MySQL database using phpMyAdmin. These CSV file contains NULL values like: "id","sourceType","name","website","location" "1","non-commercial","John Doe",NULL,"California" I imported many such csv to a PostgreSQL database with TablePlus. However, the NULL…
I've got problem with completing pgadmin4 installation thru sudo /usr/pgadmin4/bin/setup-web.sh command. During this process instalator does not recognizing that Apache is running and asks me if I want to start it: The Apache web server is not running. We can…
Docker-compose with 2 containers. 1st is a Postgres database and 2nd is a Java Spring Boot application. For running, I use further docker-compose config file: docker-compose.yml version: "3.7" services: db-service: image: postgres restart: always volumes: - /home/ec2-user/dbdata:/var/lib/postgresql/data environment: POSTGRES_USER: postgres…
I have a user table that contains a "skills" column which is a text array. Given some input array, I would like to find all the users whose skills % one or more of the entries in the input array,…
I am using Github Actions Service Container to start a postgres instance like so: name: Pull Request on: pull_request: branches: - main - staging jobs: test-and-build: runs-on: ubuntu-latest services: redis: image: redis ports: - 6379:6379 postgres: image: postgres env: POSTGRES_PASSWORD:…
I have a simple Docker Compose file to initialize a Postgres DB Instance: version: '3.8' services: my-database: container_name: my-database image: library/postgres:13.1 volumes: - ./db/init-my-database.sql:/docker-entrypoint-initdb.d/init-db-01.sql environment: - POSTGRES_DB=my-database - POSTGRES_USER=admin - POSTGRES_PASSWORD=password ports: - 10040:5432 restart: always networks: - app-network And…
I'm trying to dockerize my Rails application, but I have this error when I want to run it with docker-compose: ! Unable to load application: PG::ConnectionBad: could not connect to server: Connection refused Is the server running on host "postgres"…
I am using CentOS 8 and GitLab ci/cd and I'm trying to deploy a Django project, I don't have any idea why the Django container can not connect to Postgres container, you can see all of the configurations below: Dockerfile…