So I am working on a project Django/Postgres project. When I run docker-compose up, the project launches with Django in one container and Postgres in the other. I am able to view certain URL’s of my project, however the ones that query MyProfile model, all result in the following error: docker@postgres ERROR: relation “accounts_myprofile” does […]
I created docker postgres instance with docker run -d \ –name test_db \ -v data:/var/lib/postgresql/data \ -e “POSTGRES_PASSWORD=abcdefghij” \ -e “POSTGRES_USER=testuser” \ -p 5432:5432 \ postgres I can properly connect to this database from other hosts using public server ip, eg. psql -U testuser -h 18.104.22.168 -d testuser // in reality I use proper IP […]
I had create the dump of database which located inside docker container using this command: docker exec -it container_id pg_dump -U postgres -Fc -d database_name > local_file.dump -t flag enable pseudo-terminal mode. As a result local_file.dump is corrupted. Can I fix this binary file?
We are creating a Dockerfile that can spin up a Postgres database container, using this image as a basis https://hub.docker.com/_/postgres/ Every time we test we want to create a fresh database with the production database as a template – we want to copy the database structures without copying the data in tables etc. Can someone […]
I have this container which seems to not work, and I’m unable to figure why, it left no logs FROM debian:latest RUN apt-get update && apt-get -y install apache2 libapache2-mod-php5 RUN apt-get -y install postgresql php5-pgsql RUN apt-get update && apt-get -y install php5-common php5-cli php5-fpm php5-mcrypt php5-pgsql php5-apcu php5-gd php5-imagick php5-curl php5-intl RUN a2enmod […]
Can’t start docker with postgres, could not access private key file “/etc/ssl/private/ssl-cert-snakeoil.key The command I ran: sudo docker exec tryton-server /etc/init.d/postgresql start Error: tryton-server Starting PostgreSQL 9.4 database server: mainThe PostgreSQL server failed to start. Please check the log output: 2016-11-11 03:42:24 UTC [27-1] FATAL: could not access private key file “/etc/ssl/private/ssl-cert-snakeoil.key”: Permission denied … […]
I’m having a PostgreSQL instance running on my local machine, listening on all the interfaces (listen_addresses = ‘*’), and Docker running a Rails application which needs to connect to this database. Updating manually the pg_hba.conf file by adding a line allowing my IP address makes the application working. Now, given my computer has the IP […]
I have a python application running inside a container. The application needs to connect to PostgreSQL that is running in host (not in any other container ). I tried various approaches spread around the internet still no luck since a day. Possible reason for failure may be lack of correct implementation or Knowledge base. Any […]
I’m trying to make a php7+nginx+pgsql development environment in separated containers by docker-compose. Here’s my docker-compose.yml: webserver: build: ./nginx ports: – “8888:80” volumes: – ./site.conf:/etc/nginx/conf.d/default.conf links: – php-fpm php-fpm: build: ./php-fpm volumes: – /path/to/codes/:/var/www/ Now I’m just missing the pgsql. How to add pgsql to the docker-compose.yml?
We’re running a docker container that connects to a postgres database on the same server but not within a container. I can connect via psql or pgadmin fine but within the docklet we are seeing the following errors messages coming from Catalina. Apologies on the unformatted mess but the crux is that the following error […]