I have a Postgis database deployed on a Kubernetes cluster, using this image: docker pull postgis/postgis:13-3.1. I was trying to solve this error: 2021-06-29 03:20:50.958 UTC [2852] ERROR: relation "pg_stat_statements" does not exist at character 536 2021-06-29 03:20:50.958 UTC [2852]…
I installed Postgresql 13 to Centos 8 VM, trying to learn how to make connections secure with ssl. Though completing most of the steps and creating server and client certificates, i can't connect to my database remotely via PgAdmin with…
I am trying to query a postgres instance that lives on a remote centos (redhat 7) virtual machine. The following code: import pandas as pd, sqlalchemy engine = sqlalchemy.create_engine('postgresql://postgres:projectpassword@ip_address_of_vm/project') df = pd.read_sql_table('test_table', engine) print(df) Whee ip_address_of_vm is the ens192 inet…
In my project (Django, using Postgresql) I need to display statistics on the number of registered users by day. In the database, all time fields are stored with the UTC zone. In settings.py parameters set: USE_TZ = True TIME_ZONE =…
I'm using django with celery, celery beat, and redis to run periodic tasks. The problem I'm having is that tasks registered in celery are received but not executed. Also, the task stops in the middle even though I have not…
I've created table in PostgreSql: DROP TABLE IF EXISTS es_events; CREATE TABLE IF NOT EXISTS es_events ( id SERIAL, name VARCHAR (50) NOT NULL, version INT NOT NULL, data BYTEA NOT NULL ); now i'm trying to select from this…
I am learning Symfony, I create my project with : symfony new myproject --full directly after this I run symfony serve in the console I am getting thoses errors : Tailing Web Server log file (/Users/ben/.symfony/log/cd52af540b09d661e4ffb4f5029da4bbaf3586a9.log) Tailing PHP-FPM log file…
I am trying to improve the performance of row insertion in a postgresql 11 db using standard java prepared statements. It is standing on top of debian 11 in a VM environnement. I am using pentaho data integration and a…
I'm trying to setup cyberark's conjur solution using docker containers and a local volume to maintain persistent data. I followed the instructions in the following link: https://github.com/cyberark/conjur-quickstart What I'm experiencing is that when I perform a "docker-compose down" and then…
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…