149 questions
0
votes
0
answers
812
views
How to get postgres to clean up pg_wal at patroni standby instance?
We have a lot of postgresql clusters set up with patroni.
Most of the time and most of all clusters are behaving as expected.
But at one of the standby nodes WAL files are not removed and so pg_wal ...
- 11
1
vote
1
answer
2k
views
Forcing a WAL switch every 30 mins
I'm doing postgres pg_basebackup's (Via barman) on a primary cluster and a read only standby postgres cluster (they are in different data centres)
I'm hitting an issue on DB's with low amounts of ...
- 45
3
votes
0
answers
268
views
Turn off all monitors with Windows API
I want to turn off all monitors programmatically, as if the screen off time in Windows Settings had elapsed. This means, that any user input (e.g., keypress or mouse move) would turn the monitors back ...
- 3,537
1
vote
2
answers
990
views
Detect Modern Standby/S0 from a Windows Service
I have a Windows Service which performs network activity. This service is distributed across a few hundred PCs with a wide variety of hardware, including some tablets with either WiFi or cellular ...
- 11
2
votes
0
answers
141
views
Preventing Scheduled Task from Running During Modern Standby
I'm encountering an issue with a compiled PowerShell script (packaged as an EXE) that is scheduled to run regularly on several computers. The script performs various checks, but I've noticed that it ...
- 190
1
vote
1
answer
2k
views
Sleep Modes with Modern Standby on new PCs (Windows API)
I have a new PC that doesn't support S3 sleep, only S0. I am working on a small application to initiate various modes of sleep on command. When I run powercfg -a, it tells me the only available ...
- 182
2
votes
0
answers
313
views
How to prevent our service from running in Modern Standby
Our Program is running as a System Service in Windows installed using Topshelf. We have detected that our Service is running in small allocated intervals during Modern Standby when a comptaible device ...
- 21
0
votes
1
answer
667
views
Kafka standby replica clarity sought
I'm after some clarification on how Kafka standby replicas work for some piece of mind!
Given this scenario;
A Kafka streams application;
reading from a source topic with 10 partitions
writing to a ...
- 95
0
votes
0
answers
981
views
How can I do a Lua script for GHUB in order to switch my keyboard's lightning once my pc goes in stand by mode?
I have recently bought a new logitech keyboard and I want it to change lights whenever my pc goes in stand by mode... I have seen that you can assign scripts to your light profiles in GHUB but these ...
1
vote
0
answers
307
views
How does one set the `idle sensitivity` of Windows 11?
Essentially, when only playing music, whether via Spotify, VLC, Groove, etc., Windows11 will seemingly ignore or not receive messages to prevent idling.
I have verified that the Power Options::...
- 111
0
votes
1
answer
436
views
Need help for configuring standby DB with Oracle APEX
Hi I need configure Standby Database with Active Data Guard.
Our company uses Oracle APEX.
How to install APEX to reduce switchover downtime?
Or is it possible to install ORACLE APEX on a separate ...
0
votes
2
answers
2k
views
STM32WB : Is it possible to wakeup standby mode via BLE?
I am starting a project using STM32WB MCU. I would like to minimize the power consumption while in sleep, but able to wake it up via BLE command.
From the document AN5071(STM32WB ultra-low-power ...
- 399
0
votes
3
answers
355
views
PostgreSQL Streaming Replication Reject Insert
I have Postgresql 14 and I made streaming replication (remote_apply) for 3 nodes.
When the two standby nodes are down, if I tried to do an insert command this will show up:
WARNING: canceling wait ...
2
votes
0
answers
542
views
PostgreSQL Replication without DELETE , DROP queries
i just configured a hot standby server in order to replicate my PostgreSQL database immediately . It works perfectly , but i want to disallow [DELETE , Truncate , DROP etc..] queries from replication ...
- 21
-2
votes
1
answer
105
views
Is it possible to put a Windows PC into standby if a specific program is terminated
I would like to put my PC into standby if a specific program is manually stopped. If possible I would like a timeout to allow me to restart the program before the standby is activated.
Is this ...
- 473