workaround Archives

Tech Optimizer

June 4, 2025

Migrate Google Cloud SQL for PostgreSQL to Amazon RDS and Amazon Aurora using pglogical

PostgreSQL is a popular open-source relational database used by enterprise developers and startups, enabling rapid prototyping and supporting mission-critical applications. Amazon RDS for PostgreSQL and Amazon Aurora PostgreSQL-Compatible Edition facilitate easy setup, operation, and scaling of PostgreSQL deployments in the AWS Cloud, automating administrative tasks like software installation, storage management, and backups. The pglogical extension, compatible with PostgreSQL versions 9.4 and higher, allows for asynchronous replication and is supported on RDS for PostgreSQL and Aurora PostgreSQL from version 12. It uses a publisher/subscriber model for logical streaming replication. To migrate a PostgreSQL database from Google Cloud SQL to RDS for PostgreSQL or Aurora PostgreSQL, users must configure the primary database in Cloud SQL, create a PostgreSQL user with replication privileges, enable logical replication parameters, and create the pglogical extension. The RDS instance also requires a special user for replication, enabling logical replication parameters and creating the pglogical extension. Known limitations of pglogical include the inability to replicate primary key changes directly, the need to manually transfer extensions, and the lack of support for materialized views and large objects. Workarounds involve using surrogate keys for primary keys, manually creating extensions, and converting large objects to bytea columns or storing them in Amazon S3. DDL statements are not automatically replicated, but can be queued using the pglogical.replicate_ddl_command function.

AppWizard

June 3, 2025

Nvidia GPUs are broken in one of the most demanding new PC games, says developer

Nvidia users with RTX 40-series and 50-series GPUs may experience crashes when launching the Hell is Us demo, prompting Rogue Factor to recommend lowering graphics settings and disabling upscaling and frame generation options before starting the game. The developer is working on a patch ahead of the game's official release on September 4. Previous titles have also faced similar issues, with suggestions for Nvidia users to roll back driver installations due to ongoing driver stability challenges. The crashing issue is tentatively linked to Nvidia's DLSS technology, which has been implicated in crashes across various games. The system requirements for Hell is Us indicate that an RTX 4090 is necessary for 4K gameplay at 30 fps, while an RTX 2080 Ti is recommended for 60 fps at 1080p.

Winsage

June 3, 2025

Microsoft patches the patch that put Windows 11 in a coma

Microsoft has released a fix for a recent patch that caused some Windows 11 PCs to enter recovery mode due to an error code linked to the May Patch Tuesday update. The issue primarily affected virtual boxes and some physical devices, displaying the message: "Your PC/Device needs to be repaired. The operating system couldn't be loaded because a required file is missing or contains errors. File: ACPI.sys. Error code: 0xc0000098." The fix, identified as KB5062170, does not address an ongoing issue with Noto fonts, where CJK characters appear blurry in Chromium browsers at 100 percent scaling. Users can temporarily adjust the scaling to 125 or 150 percent to mitigate this problem. Microsoft has faced similar challenges with out-of-band fixes in the past, affecting both Windows 10 and Windows Server.

AppWizard

June 3, 2025

I created a Samsung Routine to fix the Google Play Store’s biggest failure

Trust in the Google Play Store's ability to update Android apps has decreased among users due to inconsistent update frequencies. Samsung phone users can utilize the Modes and Routines feature to automate app updates. To set this up, users need to download the Good Lock app and its Routines+ module, then create a routine that records actions in the Play Store to update apps automatically. Users can specify a trigger time for the routine to run daily. While effective, users should monitor the routine's performance and adjust as needed, as it may not always function perfectly.

Winsage

June 2, 2025

Microsoft ships emergency patch to fix Windows 11 installation issues

Microsoft has addressed a significant issue affecting certain Windows 11 systems after the installation of the KB5058405 security update from May 2025. Users reported encountering 0xc0000098 recovery errors linked to ACPI.sys, indicating that the operating system could not be loaded. This problem primarily affects Windows 11 versions 22H2 and 23H2 in enterprise settings, particularly among Azure Virtual Machines, Azure Virtual Desktop, and on-premises virtual machines hosted on platforms like Citrix or Hyper-V. Microsoft has released the KB5062170 non-security out-of-band update to resolve the installation and boot problems, which can be manually installed from the Microsoft Update Catalog. For Azure customers facing difficulties after implementing the May 2025 update, Microsoft recommends using Azure Virtual Machine repair commands as a temporary workaround. Users of Windows Home or Pro editions in home environments are unlikely to encounter these issues.

Winsage

May 30, 2025

Microsoft May Patch Tuesday fails on some Windows 11 VMs

Microsoft's recent Patch Tuesday update for Windows 11 has faced significant issues, particularly affecting users on versions 22H2 and 23H2. The installation of the May 13 update is failing on some machines, especially in virtual environments, leading to recovery mode entries and boot errors. Users are advised to avoid the update temporarily. The error message indicates a problem with the ACPI.sys file, which is crucial for managing hardware resources. Windows 11 Home and Pro users are likely unaffected, as virtual machines are typically used in enterprise settings. Microsoft has not provided the number of impacted users or a workaround beyond uninstalling the patches, but engineers are working on a resolution. This incident follows previous patching challenges faced by Microsoft this year, including an emergency update for Windows 10 and issues with Remote Desktop sessions in earlier updates.

Tech Optimizer

May 29, 2025

How to turn off antivirus

Antivirus software is crucial for digital security, providing protection against malware threats. Users may need to disable antivirus temporarily for reasons such as system resource consumption, particularly during resource-intensive tasks like gaming, or to bypass false positives when installing applications. Disabling antivirus software poses risks, especially when browsing the internet, as even legitimate sites can be compromised. Precautions to take when disabling antivirus include disconnecting from the internet, avoiding USB drives, using trusted networks, closing non-essential applications, verifying the legitimacy of downloaded files, and limiting browsing to secure websites. Users should promptly re-enable their antivirus after completing necessary tasks.

AppWizard

May 24, 2025

Signal blasts Microsoft over Recall privacy failings, as secure messaging app is forced to fudge a way of blocking the controversial Windows 11 feature

Signal has introduced a new feature in its Windows 11 application that blocks Microsoft's Recall functionality to enhance user privacy. This 'screen security' setting is activated by default for Windows 11 users and is part of Signal's efforts to protect shared content on its platform. Recall captures screenshots of user activity on Copilot+ PCs, which raised privacy concerns. While Microsoft has improved Recall, issues with its interaction with privacy-focused applications like Signal remain. The feature is specifically applicable to users with Copilot+ PCs equipped with a Neural Processing Unit (NPU). Users can disable the screen security setting through Signal Settings > Privacy > Screen security, with a warning about the privacy implications of doing so.

Winsage

May 23, 2025

Announcing Windows 11 Insider Preview Build 26120.4161 (Beta Channel)

Windows 11 Insider Preview Build 26120.4161 (KB5058515) has been released to the Beta Channel for Windows 11, version 24H2. This update includes new features such as the Microsoft 365 Text Action in Click to Do, allowing users to draft content in Word by selecting recognized text. Lock screen widget personalization is now available globally, enabling users to customize their lock screens. The update introduces support for multiple dashboards in Widgets, enhancing organization and access to favorite widgets. Improvements include recommendations from the Microsoft Store in the "Open with..." dialog and a new PC-to-PC migration experience in the Windows Backup app. Various fixes have been made to the Start Menu, Task Manager, Narrator, and Voice Access. Known issues include incorrect build version display post-PC reset and Bluetooth issues with Xbox Controllers. Users are encouraged to provide feedback through the Feedback Hub.

Winsage

May 23, 2025

Signal Will Black Out Windows Recall Screenshots to Preserve Privacy

Signal has introduced a "screen security" feature for its Windows 11 application to counter Microsoft's Windows Recall, an AI feature that captures screenshots of user activities. This new feature ensures that any attempts by Recall to take screenshots will result in a black screen. Signal's blog post notes that while the feature enhances privacy, it may cause compatibility issues with some accessibility tools, and users can disable it if necessary. The feature only protects the local machine and does not prevent other conversation participants from taking screenshots. Signal criticized Recall for lacking built-in privacy controls for app developers and emphasized the need for operating system developers to prioritize user privacy. The screen security feature is being rolled out and is enabled by default for Windows 11 users.