I found a Django project and failed to get it running in Docker container in the following way: git clone https://github.com/hotdogee/django-blast.git $ cat requirements.txt in this files the below dependencies had to be updated: kombu==3.0.30 psycopg2==2.8.6 I have the following…
I am not an expert at Postgres/GIS subjects and I have an issue with a large database (over 20 million records) of geometries. First of all my set up looks like this: mmt=# select version(); -[ RECORD 1 ]------------------------------------------------------------------------------------------------------------- version…
I have a Postgres 11 database installed on a VirtualBox virtual machine running Centos7 (guest machine), and my host machine is a Mac OS Catalina. Both the guest (Centos) and host (Catalina) have JDK 8 installed. I have the following…
I am a newbie trying to follow this tutorial. https://testdriven.io/blog/dockerizing-django-with-postgres-gunicorn-and-nginx/#postgres I succeeded in building the docker containers but got this error django.db.utils.OperationalError: FATAL: password authentication failed for user "postgres". My question is why has authentication failed when the python and…
After installing OpenVAS on Kali linux, ran gvm-setup command to setup GVM as per instructions: https://linuxhint.com/install-openvas-kali-linux/ However, the following error ocurred: ERROR: The default postgresql version is not 13 required by libgvmd Error: Use pg_upgradecluster to update your postgres cluster…
I've made csv-backup from SELECT query and now trying to import it back to the database. But i am getting this error: COPY doc FROM '/tmp/doc.csv' DELIMITER ',' CSV HEADER; ERROR: invalid input syntax for type uuid: "null" As you…
I am trying to run a CI system which works for DB migration scripts. So this could prevent us from running sql scripts which do not work at the migration time because of syntax errors. For our local setup we…
I have a docker compose setup that was working before (for several months) but after restarting the Pi its now not working :( Whats to be noted is that when pointing the DB to an empty DB folder, there are…
I'm trying to connect to Postgres using JDBC. The database is running in the Docker container. I am using Windows Docker Desktop (Windows 10 pro) with WSL2. I launch the Docker container using docker-compose. Here is the content of docker-compose:…
I am using this website analytics tool: Umami I am currently looking at the postgresql.conf file and I see that max_connections is set to 100. At peak times, my site may have 1000 concurrent users. Is Postgresql configured to support…