guidance 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.

Winsage

June 4, 2025

Microsoft accused of ‘tech extortion’ over Windows 10 support ending in campaign to get people to upgrade to Linux

KDE has launched a campaign called ‘KDE for Windows 10 Exiles’ to encourage Windows 10 users to switch to Linux as support for Windows 10 is set to end on October 14. The campaign warns that without updates, users will face increased security risks and be pressured to buy new hardware for Windows 11, which has stringent requirements that may render older PCs incompatible. The initiative also highlights environmental concerns related to electronic waste from discarded functioning machines. While Linux can extend the life of older hardware, transitioning to it may be challenging for less tech-savvy users. Some KDE contributors are involved in the existing ‘End of 10’ initiative, indicating a shared goal to attract users dissatisfied with Microsoft’s practices.

AppWizard

June 2, 2025

Singleplayer Elden Ring Nightreign is no longer hell to play, but it’s still a compromised game of 30-minute boss runbacks

The author, known as Mr. Antisocial Souls, typically prefers solo gaming, especially with FromSoftware titles, but found Elden Ring Nightreign's multiplayer aspect engaging. Initially expecting to play solo, they discovered that the single-player experience highlighted the game's flaws. Recent patches have improved solo gameplay, making it more enjoyable, although challenges remain, such as navigating the interface and dealing with punishing RNG. The game’s boss encounters are designed for teams, making solo play feel more difficult and disheartening. Improvements include balanced self-revivals and enemy health adjustments, enhancing solo playability. However, the author suggests limiting solo play to 15% of total gaming time for optimal enjoyment, as the experience is better with a team.

Winsage

June 2, 2025

Microsoft Issues New Emergency Update For Windows Users

Microsoft has released an emergency out-of-band update, KB5062170, to address issues from the May 13, 2025 Windows security update (KB5058405), which failed to install on some Windows 11 devices, showing error code 0xc0000098. The new update fixes an issue with the ACPI.sys driver and is available via the Update Catalog. It primarily impacts enterprise environments, particularly virtual setups like Azure Virtual Machines and Azure Virtual Desktop, while home users are less affected. KB5062170 includes all enhancements from the May 2025 non-security preview update and supersedes prior updates, requiring a device restart after installation.

AppWizard

June 1, 2025

Why Elden Ring: Nightreign is both a hit and a headache for fans

Elden Ring Nightreign is a multiplayer game developed by FromSoftware, featuring fast-paced combat mechanics and eight distinct characters called Nightfarers, each with unique strengths and weaknesses. Players aim to defeat the Nightlord while surviving three in-game days on Limvel Island, facing various bosses and challenges, including a night boss that tests their skills. The game lasts approximately 14 real-time minutes per day, with a storm circle that closes in, causing damage if players do not move. Players can unlock new characters and relics through boss victories. The game is available on PC, PS4, PS5, Xbox One, and Xbox Series consoles, priced at an undisclosed amount. It has received a mixed reception, with a 78% aggregate score on OpenCritic and a "Mixed" rating on Steam from over 31,000 reviews. Players have expressed frustration with solo difficulty and matchmaking issues. In response, FromSoftware plans to release patch 1.02 to introduce automatic revivals for solo players and increase rewards. A mod called Seamless Co-Op allows PC players to team up without needing a third player.

AppWizard

May 30, 2025

Epic Games is giving away two great PC games for free! Have you picked them up yet?

The Epic Games Store is offering free PC games this week, including Limbo and Tiny Tina's Wonderlands, available until next Thursday at 16:59 p.m. Limbo features black and white graphics, minimalistic storytelling without text or dialogue, and a tense atmosphere as players navigate traps and puzzles. Tiny Tina's Wonderlands is set in the Borderlands universe with a fantasy twist, combining shooter and RPG elements, featuring colorful gameplay, absurd enemies, and humor, with Ashly Burch voicing Tiny Tina.

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.

Winsage

May 28, 2025

Did Microsoft Change Windows 11 Requirements? – Here’s the Truth

Microsoft has not changed the official requirements for Windows 11 since its launch. Users need a compatible 64-bit processor (1GHz or faster with at least two cores), a minimum of 4GB of RAM, and 64GB of storage. Essential features include UEFI firmware that supports Secure Boot and TPM version 2.0, DirectX 12 compatible graphics with a WDDM 2.0 driver, and displays of at least 9 inches with a resolution of 720p. Microsoft allows experienced users to manually install Windows 11 on unsupported devices at their own risk, but this is not advisable due to potential issues. The strict requirements are intended to enhance security and performance. Users can check compatibility with the PC Health Check Tool. Microsoft will support Windows 10 until October 14, 2025, after which there will be no official support. For those whose systems do not meet the specifications, upgrading hardware or purchasing a new PC may be necessary.

Winsage

May 28, 2025

All Windows users must ‘watch out’ and delete ‘Microsoft’ updates now

Windows 10 and Windows 11 users are experiencing a rise in phishing emails that appear to be from Microsoft, according to Action Fraud, the UK's national fraud and cybercrime reporting center. Over 250 users have reported receiving fraudulent messages claiming their devices are infected with malware, often encouraging them to click on malicious links. These emails may look credible, sometimes using legitimate Microsoft addresses. Action Fraud advises users to verify messages directly with organizations using official contact details and warns that legitimate institutions will never request personal information via email. Microsoft also states it does not send unsolicited emails or calls for personal information and recommends downloading software only from official sources.

AppWizard

May 28, 2025

This rumored One UI 8 feature might be just what runners need

Samsung is developing a personalized virtual Running Coach as part of its One UI 8, based on Android 16. This feature will provide tailored assessments to enhance running performance and offer guidance during longer runs. The coach will evaluate users' progress and intensity, helping them balance their training. Integration with Galaxy Watch may allow for real-time heart rate monitoring. A One UI 8 beta banner has appeared in the Samsung members app, indicating the upcoming upgrade. Additionally, One UI 8 may include a redesign of the Gallery and Files Manager apps, and an upgraded Secure Folder with new Private Space functionality for secure content storage. The rollout of One UI 8 is anticipated as Google prepares to launch Android 16 in Q2 2025.