Postgres and Open Source Experts

Anytime. Anywhere. Since 1997.

Blog

Less is More

Sometimes, after using a tool for many years, you will discover a feature that totally changes how you do things. When it is a fundamental tool like “less”, it changes how you interact with many command line programs in Linux*.

Did you know that less can do far more than just press space to advance to the next page? I sure didn’t. Then one day I went down the rabbit …

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.

The Importance of Language

After a short walk in the late afternoon sunshine, I found myself praising my noble steeds who come with me almost everywhere; aka my frenchtons. Moose, I’d argue the most sweet and stubborn frenchton, has Intervertebral Disk Disease (IVDD). This means most of what he does has to be monitored carefully as it takes more out of him and can lead to serious injury. It also means he and I …

PgManage 1.0rc1 released

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

Embrace Creative Living

“The universe buries strange jewels deep within us all, and then stands back to see if we can find them. The hunt to discover those jewels––that's creative living.”
Elizabeth Gilbert, Big Magic: Creative Living Beyond Fear

A couple of years ago I was at Huntington Beach State Park in South Carolina pacing up and down the path to the beach. I was talking to my therapist and out came …

How to Set Yourself Up for a Successful Meeting

There are a lot of mugs out there that say “I survived another meeting that should have been an email.” We’ve all been there, and more likely than not we have also facilitated meetings that others may throw in the “should have been an email” bucket. We’re busy and it happens. Meetings are constant, burdensome, and necessary. As a fellow survivor and bucket avoider, I’ve put together a few simple …

Get back on that horse

A few years ago I was diagnosed with a variety of conditions that came with the term “chronic.” Throughout the grief process, my partner encouraged me to write about it. It was uncomfortable to be publicly vulnerable in a professional world where “weakness = bad.” I sat there knowing logically that vulnerability was a sign of strength, but the risk adverse [read: scared] side of me still wasn’t convinced. How …

Embracing Wellness: Our Journey Begins

Introducing the Command Prompt Health & Mental Wellness campaign, a holistic approach to life.

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 …