statuses

Tech Optimizer
February 27, 2025
Proxima integrates connection pooling, query proxying, and load balancing into the Postgres Pro Enterprise DBMS, enhancing efficiency and minimizing latency. It establishes multiple connections for client sessions, optimizes resource usage, and alleviates server burdens. Proxima redirects client queries to the leader node in a BiHA cluster, automating cluster topology management. Load balancing is under development to prevent overload on replicas. The pgpro_queue extension facilitates asynchronous message processing directly within the database, ensuring transactionality, prioritization, filtering, and reliable message storage. Postgres Pro 17 Enterprise introduces enhanced query plan management tools, including the pgpro_multiplan extension for storing multiple execution plans and a query registration assistant for managing queries. Adaptive Query Execution (AQE) and Adaptive Query Optimization (AQO Enterprise) improve complex query execution by dynamically rescheduling long-running queries and correcting planner errors based on execution history. Security enhancements include the pgpro_usage extension for tracking database object usage and identifying unnecessary access rights. The pgpro_ilm extension automates storage optimization by relocating rarely accessed data and compressing it. Infrastructure improvements include BiHA enhancements, multimaster support, and improved management of partitioned tables, along with the updated PPEM 2.0 for better UI and automatic instance tuning.
Winsage
February 24, 2025
TSforge is a new exploit developed by researchers that can activate all versions of Windows from Windows 7 onward, as well as all Office versions since Office 2013. It utilizes a technique called the "CID trick," which modifies the CID validation code in sppobjs.dll to allow the use of a counterfeit CID for activation. This activation persists even after service restarts. The researchers identified key locations for activation data storage, including specific files and registry keys that form the "trusted store." They used leaked Windows beta builds to understand the spsys.sys driver and reverse-engineered components to extract private RSA keys for decrypting and re-encrypting the activation data. TSforge can activate any Windows edition without debuggers or kernel exploits and bypasses hardware ID validation and the PKEY2005 encoding system.
Search