I've been trying to configure my m1 to work with an older ruby on rails api and I think in the process I've broken my ability to connect any of my python apis to their database images in docker running…
FROM python:3.9.5 RUN apt-get update && apt-get install -y postgresql-client-11 for Dockerfile above, docker build commands works smoothly. But FROM python:3.9.6 RUN apt-get update && apt-get install -y postgresql-client-11 docker build throws the following error. #5 2.088 Get:6 http://deb.debian.org/debian bullseye-updates/main…
I am trying to connect Strapi with PostgreSQL database. I am also using Docker in order to compose the "db". I have managed to make the PostgreSQL running on port 5432, and I am also able to connect to the…
I am running two postgres servers as containers from docker-compose on different ports. In pgAdmin, only standard port mapping 5432:5432 is possible to connect. The second server mapped as 5433:5432 to avoid conflict is impossible to connect. Both server containers…
I am trying to speed up a delete query that appears to be very slow when compared to an identical select query: Slow delete query: https://explain.depesz.com/s/kkWJ delete from processed.token_utxo where token_utxo.output_tx_time >= (select '2022-03-01T00:00:00+00:00'::timestamp with time zone) and token_utxo.output_tx_time <…
I use nextjs fresh project with Prisma and supabase database. I'm using ubuntu. No LSB modules are available. Distributor ID: Ubuntu Description: Ubuntu 22.04 LTS Release: 22.04 Codename: jammy when I run Prisma push and generate command in my project.…
Here is the scenario, I'm deploying the Django app on an ec2 instance. I'm following this guide Digitalocean deployment guide. when I run my app using python manange.py runserver 0.0.0.0:800 and access the admin portal via http://server-ip-address:8000. everything works fine.…
I am a newbie to SpringBoot. I am trying to create a spring boot application which i am running using docker. when i run this app, i get the following error org.postgresql.util.PSQLException: FATAL: role "amigoscode" does not exist I don't…
I have a problem with my django + postgresql docker compose. docker-compose.yml: version: '3.8' services: db: image: postgres:12.0-alpine volumes: - postgres_data:/var/lib/postgresql/data/ env_file: - ./.env web: build: . command: python MoreEnergy/manage.py runserver 0.0.0.0:8000 volumes: - ./MoreEnergy/:/MoreEnergy/ ports: - 8000:8000 env_file: -…
I'm trying to upgrade PostgreSQL from 11 to 13 on a Debian system, but it fails. I have a single cluster that needs to be upgraded: $ sudo -u postgres pg_lsclusters Ver Cluster Port Status Owner Data directory Log file…