postgres | tools for managing postgres | Database library

I try to write a (postgres) sql query which returns the last rows before a specific numeric column drops below it's preceding value, for multiple services.

Let's say the given data looks like:

I'm trying to learn Flask and use postgresql with it. I'm following this tutorial https://realpython.com/flask-by-example-part-2-postgres-sqlalchemy-and-alembic/, but I keep getting error.

Are the following queries identical, or might I get different results (in any major DB system, e.g. MSSQL, MySQL, Postgres, SQLite):

Doing both in the same query:

I am using the following docker-compose image, I got this image from: https://github.com/apache/airflow/blob/main/docs/apache-airflow/start/docker-compose.yaml

so I've got this model:

I am using a postgres database for the first time. I am using python 3 in miniconda in Windows 10 and Lubuntu.

I want to start my database server from my python script (on the cron). When it starts, nothing else get executed in my script. Do I need multi-threading or it's something else?

thanks everyone

I have master-slave (primary-standby) streaming replication set up on 2 physical nodes. Although the replication is working correctly and walsender and walreceiver both work fine, the files in the pg_wal folder on the slave node are not getting removed. This is a problem I have been facing every time I try to bring the slave node back after a crash. Here are the details of the problem:

postgresql.conf on master and slave/standby node

Attempting to use cyrilgdn/postgresql provider but terraform continues to attempt to load hashicorp/postgresql, this causes init to fail. Currently using terraform 1.0.0, although the problems happens on 14.1 too - have not upgraded from 12.x, always run 14.1 or newer on this work.

I've reduced the code to the below, nothing else in this folder and still get the problem

I have 5 different tables:

• Toasters: product name (foreign key to products and primary key), slots, serial
• Microwaves: product name (same as toaster), wattage
• Products: product name (primary key)
• Stock: product (fk to product), warehouse (fk to warehouse), amount
• Warehouse: name (primary key)

toasters and microwaves are child tables of products (although its not using postgres inheritance, since there are issues with it). They represent different models of toasters (simplified to just slots and wattage here). Every toaster and microwave has exactly 1 entry in the products table.

Now the goal is to create a query that essentially gives me an amount of all products across all warehouses for a given list of product names. The problem is, that some warehouses may not have a stock entry for a certain product. They also have either one stock per product or none.

I have managed to make it work for a single warehouse: