PgManage 1.0 released, grab it today!
Blog
Getting Started with pgBackRest: Perform Your First Backup
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
PgManage 1.0rc1 released - an inch closer to being a mile ahead
An act of kindness for the PostgreSQL community
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.
Courtesy Notification: CVE-2020-21469 PostgreSQL 12.2 Security Vulnerability
This is a courtesy notification to our clients and community regarding an alleged security issue for PostgreSQL 12.2.
The following issue was reported as CVE-2020-21469:
An issue discovered in PostgreSQL 12.2 allows attackers to cause a denial of service via repeatedly sending SIGHUP signals.
This is not a security vulnerability, and was filed without prior knowledge of or consultation with the PostgreSQL Security Team as reported in this …
PgManage 1.0b2 released
PgManage 1.0b2 released.
PgManage 1.0b released
Command Prompt is pleased to announce PgManage version 1.0b. This release adds two major features, 3 major bug fixes and over a dozen changes and improvements. PgManage is a Postgres centered multi-database management Open Source project.
New features:
- Added backup/restore support for PostgreSQL
- First version of PgManage Handbook was published to https://pgmanage.readthedocs.io/en/latest
Major Bugs fixed:
- Fixed .AppImage compatibility issues for newer Linux distributions which do not have libcrypt installed
- Added …
Announcing PgManage 1.0a
PgManage is a Postgres centered multi-database management Open Source project. It is a fork of the previously well received project OmniDB that had been abandoned. Command Prompt has taken the helm of this project to ensure a quality project focused on the Management of PostgreSQL and related technologies.
- Source: https://github.com/commandprompt/pgmanage
- Website and Binaries: https://commandprompt.com/products/pgmanage/
- Full Documentation: https://pgmanage.readthedocs.io/en/latest/
- Community: https://discord.gg/FvweAhhUeu
Major Changes from OmniDB
New features:
- new connection management UI
- added …
PostgreSQL and Financial Calculations - Part Five
The fifth and last in a series of blogs covering common mistakes in Database and Application designs for financial calculations.
Method of Rounding:
There are many methods of rounding
- Half Round Up
- Half Round Down
- Round Towards Zero
- Round Away from Zero
- Round Half To Even
- Round Half To Odd
- Random Round
The built-in method of rounding in PostgreSQL is Half Round Up. Unfortunately, it is not the best approach, …
PostgreSQL and Financial Calculations - Part Four
The fourth in a series of blogs covering common mistakes in Database and Application designs for financial calculations.
Database Driver, or Application Framework Created Error:
The database driver or application framework created errors are probably the hardest to find, as we are the consumer not the writer of the tool, with many assuming the casting is correct. However, we must review the documentation or the library’s code to know how …