Tag: postgresql

Installing psycopg2 in an alpine docker container

I am trying to get my django application to use PostgreSQL, however, so far no luck. I set the application to use the PostgreSQL database and linked both containers using docker-compose.yml, but I am getting the error that the module psycopg2 is missing. I installed all of the dependencies as follow: apk –update add python3-dev, […]

(psycopg2.OperationalError) could not connect to server: Connection refused Is the server

I am trying to connect two docker containers, one posgresql and the other a python flask application. both are linking correctly, all connection variables in the python app are taken directly from the ones in the postgres container that are exposed via linking and are identical to those found when inspecting the postgresql container. when […]

CentOS with Systemd on Docker

I am actually working on automated testing of my playbooks with Gitlab-CI, Ubuntu is working very well and getting no issues. The Problem actually I have is with CentOS and Systemd, first of all the Playbook ( installing Postgres 9.5 inside CentOS7): – name: Ensure PostgreSQL is running service: name: postgresql-9.5 state: restarted ignore_errors: true […]

RubyMine connect to database

I’m using latest version of RubyMine and when I try to connect to my docker container database, I see the database, but not any of the tables etc. If I use an external program such as Psequal using the exact same credentials, it works fine so I know I’m using the correct credentials, IP address […]

List docker database with local databases

i have two docker containers running, following the instructions given here: https://github.com/swri-robotics/bag-database. I can now look at the database in the browser using: localhost:8080, so it’s set up properly and running fine. So my question is, how can I get the other container that is running on port 5432 to list the database with all […]

Issue linking containers in Docker using Docker-compose

I’m using Docker to get my micro services architecture ready. I’m facing some problem trying to link one container with another using docker-compose. Basically I have a container for a postgressql image, and the a java micro service developed with spring boot that should connect to the database container. So I’m setting a link in […]

How to manage multiple database schema from simple docker?

For my application,i am using multiple databases.I want to run/upgrade schema for all those databases from one place(for management purpose).It is cumbersome process(specially in production/integration phase) to go to all databases and run/upgrade schema after every release or whenever some changes in schema.We thought of using simple docker for this purpose. Anyone has idea whether […]

Running docker with pgadmin on mac getting Error: Unable to initialize GTK+, is DISPLAY set properly?

I am trying to run pgadmin from my mac (Sierra 10.12.4) as described here docker run –rm –name pgadmin –link postgres:postgres -v /tmp/.X11-unix:/tmp/.X11-unix -e DISPLAY=unix$DISPLAY mdouchement/pgadmin3:1.20.0 but I am getting this error: Error: Unable to initialize GTK+, is DISPLAY set properly? how can I run docker pgadmin ?

PostgreSQL Horizontal scaling for “database per customer” cloud service

I’m looking for the best way to serve thousands of PostgreSQL databases for application tier. Each database is used for a specific customer. The goals are: 1. Serve as much databases on minimal hardware (reduce cost) 2. Support horizontal scaling (so I can add more servers as more customers join). 3. Move databases between servers […]

PostgreSQL on AWS ECS: psycopg2.OperationalError invalid port number 5432

I’m having a problem with database connection via psycopg2 on AWS ECS. I have an App container and a DB container. Containers are linked. The App has an entrypoint script that checks if the DB is up before starting an app server. $ until psql -h “$DB_HOST” -U “$DB_USER” -c ” && >&2 echo “Postgres […]

Docker will be the best open platform for developers and sysadmins to build, ship, and run distributed applications.