My docker contianer django server, postgres, celery worker and celery beat. Running the application by itself there is no issue with connecting to the database however when the timed task to update the database runs I get an error celery_1…
I'm working for a certain trader and he wants to build a relatively huge archive of stock quotes for further analysis. We have an access to information provider, and the data always have the same structure: ticker name, timestamp, and…
Have a CentOS7 Linux machine running (not managed by me; have limited rights to/in it). Have a request to set PostgreSQL up in it. Just installed PostgreSQL from the CentOS repository: sudo yum install postgresql-server postgresql-contrib All good with it.…
I have read in a couple of places that some databases use bloom filters for finding a match when querying a database. In my example I'm using Postgresql which is one of those databases. My question comes up when talking…
I'm trying my level best to reduce server space by deleting the unnecessary file and I come across with this file with huge space after running this command [root$]# du -a / 2>/dev/null | sort -n -r | head -n…
So far I have downloaded GNAT GPS Community and installed this on my Linux Centos 7 machine. My objective is to be able to complete these two online examples: 1: http://bisaga.com/blog/programming/ada-database-first-steps/ 2: https://docs.adacore.com/gnatcoll-docs/sql.html To do this I need to install…
For the HelpCovid GPLv3+ project (C++17, Linux/x86-64, Debian/Buster, PostgreSQL 11 or 12) and its issue #27, we want to clear all the data in a given PostgreSQL 11 (or 12) database. We have today (April 6, 2020, git commit 2843184d9f589d51bd9)…
I have a problem with the following sorting: SELECT name FROM unnest(ARRAY[ 'MIR1290', 'MIR1291', 'MIR129-1', 'MIR1292', 'MIR129-2', 'MIR1293', 'MIR1294', 'MIR1296', 'MIR1297', 'MIR1298', 'MIR1299' ]) name ORDER BY name; In one server is sorted as follows: "name" "MIR1290" "MIR129-1" "MIR1291" "MIR129-2"…
I have a VPS hosting with a domain redirecting to it. I have LAMP stack for my main website using WordPress CMS. Plus I am using Odoo as my back-end with python and PostgreSQL in a sub-domain. Everything was working…
I am trying to set up a postgres container to start and run initializing the creation of a table. I've succeeded with the straight image from docker but now that I am trying to extend the image a little to…