Postgres and Open Source Experts

The latest version of PgManage has been released! PgManage 1.2 Release introduces new features and improvements, and addresses several bugs reported since the last release. Please update to the latest version at your earliest convenience.

New features:

• Implemented support for adding/changing table indexes in Schema Editor
• Implemented Postgres role editor
• Added SQL error annotations in the query editor
• Significant code completion improvements: added context-aware schema, table, view, column and function …

Planning and road-mapping updates not only address immediate issues but also contribute to long-term stability and security, helping your organization avoid major headaches down the road.

The PostgreSQL Global Development Group recently released important updates for several supported PostgreSQL versions, including 16.4, 15.8, 14.13, 13.16, 12.20, as well as the 17 Beta 3. One security vulnerability and over 55 bugs were addressed, many of which affect PostgreSQL 16 and other supported versions.

As the summer winds down, many of us have experienced a professional lull with school breaks and summer vacations.

This transition offers a golden opportunity to prepare for a successful fall. Our team of System Admins and DBAs has compiled top strategies to make the most of this period:

1. Plan and roadmap future updates.
2. Determine which OS updates you’ve been putting off and do them
   1. Execute pending OS and database …

Global IT Outage: The Impact on Windows Systems and the Case for Open Source Alternatives

PgManage 1.1, a usable Open Source Postgres manager, has been released

PgManage 1.0 released, grab it today!

pgBackRest is a complete backup and continuous archiving solution for PostgreSQL offering support for point-in-time recovery (PITR), fast multi-threaded backup and restore, compression and encryption of backups, and more. In this article, we will explore pgBackRest’s features and present how to set up a basic pgBackRest configuration.

PgManage 1.0rc1 released - an inch closer to being a mile ahead

Since at least 2021 there has been a disagreement between Postgres related non-profit organizations. On one side are two affiliate non-profits for Postgresql.org; on the other is a relatively unknown non-profit out of Spain. Lines have been drawn, feet have dug in, and a lot of unproductive discourse has occurred. This has culminated in legal action, bad blood, and some poor decisions.