I have a table with monthly amounts per ID, where in some of these months an invoice takes place. My table looks like: ID Date Invoiced Amount AAA 2023-01 0 10 AAA 2023-02 0 15 AAA 2023-03 1 15 AAA…
I'm not really good at network, I can't see what changed with the command wget inside when I ran docker build --build-arg https_proxy="http://proxy-fg:8080/" and wget outside from the vm? Any ideas? [root@LQL-BDDBAS01 pg13]# export https_proxy=http://proxy-fg:8080/ [root@LQL-BDDBAS01 pg13]# wget -O postgresql.tar.bz2…
Issue I'm trying to configure the BarmanObjectStoreConfiguration for my Cloud Native PostgreSQL (CNPG) deployment, but I'm encountering an SSL validation error. Here's the error message I'm getting: "SSL validation failed for <S3_ENDPOINT/BUCKET> [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get…
I refresh my indexes in my Postgresql database with the "reindex index concurrently" command. However, I never renewed my primary key indexes because it might damage my primary key indexes or cause problems. My question is: Is there any harm…
I've noticed that some of my queries using pgroonga text search and involving multiple tables, are slow. Looking into the problem I've noticed that for some unknown reasons, postgres planner, tends to use improper indexes, instead of the proonga ones,…
I'm still a novice to sql, using Postgres. i have two tables: table request order_id amount_requested 51 5 25 8 12 1 table response order_id amount_added 51 5 25 4 12 0 I am trying to get only the order_id's…
In the Postgres view I am querying I have an array property representing tags that have been assigned to a record. I want to be able to query that array for a fragment of an entry so that, for example,…
I am encountering an issue while persisting data in a PostgreSQL database where I have a birthday field of type date. The problem arises when I attempt to save data as it throws an error indicating that it only accepts…
I am trying to generate all the commands to empty all the tables in my database. Right now I'm using DBeaver and my database is PostgreSQL: DO $$ DECLARE table_name TEXT; delete_commands TEXT := ''; BEGIN FOR table_rec IN SELECT…
I'm working an events feature, and I'm running into a rather involved query. Here's the models for reference: class Event < ApplicationRecord has_one :party belongs_to :host, foreign_key: :host_id, class_name: 'User' belongs_to :convention, optional: true has_many :join_requests ... end I'm looking…