Hello for some reason my postgres keeps restarting basically this is my docker compose: version: "3.7" services: db: image: postgres:12 restart: always container_name: "db" ports: - "${DB_PORT}:5432" volumes: - ./pgdata:/var/lib/postgresql/data environment: POSTGRES_USER: ${DB_USER} POSTGRES_PASSWORD: ${DB_PASS} POSTGRES_DB: ${DB_NAME} api: image: server_emasa…
I try to implement Apache Airflow with the CeleryExecutor. For the database I use Postgres, for the celery message queue I use Redis. When using LocalExecutor everything works fine, but when I set the CeleryExecutor in the airflow.cfg and want…
I try to mapping folder on the host to postgres container in order to save my data even if container destroy. Firstly I created new directory pg-data Secondly I describe container in docker-compose.yml version: '3.7' networks: backend-network: driver: bridge frontend-network:…
I getting started on Java programming, and I have a CentOS 7.7.1908 VM with Java 1.8.0_242 OpenJDK and my IDE is Apache Netbeans 11.3. I am trying to develop a small program to read data from standard input and save…
There is not this kind of question including docker-compose. I couldn't find what is the problem with my docker-compose.yml file. By the way, I don't want to use ready "wp-postgres" image on the docker hub. version: '3.1' services: wordpress: image:…
I try to install semver on my Postgresql 12. I installed postgis successfully and used following command to install pg-semver (semver extension) on my Centos 7 server: yum install pg-semver Then i ran CREATE EXTENSION semver; I got following error:…
Official Instructions I have been trying to install PostgreSQL 12 but I get the following error: No match for argument: postgresql12 Error: Unable to find a match: postgresql12 When I run the command sudo dnf repolist this is what I…
In my PostgreSQL database I have table with such structure: | organization_id | organization_name | parent_organization_id | tree_organization_id | |-----------------|-------------------|------------------------|----------------------| | 1 | Alphabet | | | | 2 | Google | 1 | 12 | | 3 | Google…
I've read over 20 different questions with the same problem - and the suggested answers didn't solve my problem. I'm still getting sqlalchemy psycopg2.errors.InsufficientPrivilege: permission denied for relation <<table>> Environment: EC2, debian 8, postgresql, flask, sqlalchemy my table in postgresql:…
I am running rails + Redis + Postgres with docker and I have managed to finally get everything working the only thing i can't figure out is the database. it seems that no matter what I put for host/username/password I…