Tag: postgresql

Postgres Docker – unable to connect from remote server

I am using postgres:9.5.3 docker image. I am starting the containers and then trying to connect to the psql database from a remote host but each time it fails with the error: psql: could not connect to server: Connection refused Is the server running on host “172.18.0.2” and accepting TCP/IP connections on port 5432? In […]

Running Supervisord on Ubuntu in Docker

I’m trying to use supervisor to start nginx and postgresql on boot of a docker container. Using the following Dockerfile and supervisord.conf files, the aforementioned applications start but moments later stop. Does anyone know what could be wrong? There are no error messages to stderr or system log files. Dockerfile: FROM ubuntu:14.04 RUN mkdir -p […]

Micro-components architecture with python / Django / Drf

I have several applications in my Django project: – ticker – payments – crypto – referrals – core I am using Docker wrapped by Wercker (quite limiting I would say, but saves time). My question is, how to deploy each application as a standalone container as a start, and a standalone VPS Node in the […]

Docker – few containers

Who could explain how create and connect one to other docker containers. I need info how connect one container with Nginx to second container with PostgreSQL. How make this relation? First container with Nginx should get info from second container with Postgre. I know how create container, how start service but i don’t know how […]

Add Image to my Base Docker Image

I have a docker base image that runs CentOS 6.5. This image is saved on my computer. I could not find anything that talks about how to add more images into this base image. So for example I have this base image of CentOS6.5, I need too add postgresql 9.3, and php too this base […]

How can I Enable Unaccent for postgres in Docker-Compose?

I need to enable the accents for postgreSQL. This is my docker-compose.yml, but it doesn’t work. Any tips? Thank you. db: image: postgres ports: – 5432 environment: DB_UNACCENT: true mailcatcher: image: aboutsource/mailcatcher ports: – “1080:1080” web: build: . command: passenger start –port 3000 volumes: – .:/myapp environment: – RAILS_ENV=development ports: – “3000:3000” – “25:25” – […]

What is POSTGIS_VERSION 2.1.7+dfsg-3~94.git954a8d0.pgdg80+1?

I can understand 2.1.7 but what is +dfsg-3~94.git954a8d0.pgdg80+1 coming after that ? I am now build postgis docker container from appropriate/docker-postgis and am getting error E: Version ‘2.1.7+dfsg-3~94.git954a8d0.pgdg80+1’ for ‘postgresql-9.3-postgis-2.1’ was not found E: Version ‘2.1.7+dfsg-3~94.git954a8d0.pgdg80+1’ for ‘postgis’ was not found seems to be a problem of package management? How could I find fix this? […]

Postgresql with docker: FATAL: could not read permissions of directory: Permission denied

I’m trying to dockerize a postgresql server while persisting the data on the host. My container works fine without mounting volumes from the host, but it crashes because of permissions with those volumes: FATAL: could not read permissions of directory “/var/lib/postgresql/9.4/main”: Permission denied my docker run command is docker run -p 54332:5432 -v `pwd`/volumes/postgres/log:/var/log/postgresql -v […]

Understanding how to import a map.osm file into a postgres database.

I was just reading a tutorial HERE. I am assigned with the following task: The task is to create a Docker image that has PostgreSQL installed. The PostgreSQL database should be PostGIS-enabled. The Docker image should also allow quick and easy import of an .osm map data file into the database. The database should contain […]

How do I expose Docker a Docker port via Kubernetes in Google Cloud?

I am trying to wrap my head around provisioning Docker instances in Kubernetes on Google Cloud. I have build a replica controller that specifies a single pod and defined a port to be exposed, but it is not being exposed. Here is my containers.yaml: apiVersion: v1 kind: ReplicationController metadata: name: postgres spec: replicas: 1 selector: […]

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