by Sagar Jadhav | Dec 22, 2022 | Insight for DBAs, PostgreSQL
PostgreSQL manages database access permissions using the concept of roles. A role can be either a database user or a group of database users, depending on how the role is set up. Roles can own the database objects and assign privileges on those objects to other roles...
by Abdul Sayeed | Dec 14, 2022 | Insight for DBAs, PostgreSQL
In one of our previous posts Detailed Logging for Enterprise-Grade PostgreSQL, we discussed parameters to enable detailed logging and use Log Analyzer – pgBadger. In this blog post, we will configure a Microsoft Azure provisioned PostgreSQL Flexi Server to populate...
by Robert Bernier | Dec 14, 2022 | Insight for DBAs, PostgreSQL
Prologue This blog is the result of my investigation into column-wise tables. Hopefully, you will find it useful in your deliberations. When I started writing it was meant to be a “Good News” blurb. I was pretty optimistic that I’d truly have impressive numbers to...
by David Stokes | Dec 7, 2022 | Open Source, PostgreSQL
There is an interesting project by the folks at PostgresPro that is translating Egor Rogov’s PostgreSQL 14 Internals into English. This an ongoing project being released as they make progress in providing a great resource to the PostgreSQL Community. Parts I...
by Jobin Augustine | Dec 2, 2022 | Insight for DBAs, PostgreSQL
PostgreSQL traditionally uses shell commands to achieve continuous WAL archiving, which is essential for backups and stable standby replication. In the past, we blogged about the inefficiency in that design and how some of the backup tools like PgBackRest solve that...
by Bhargav Kamineni | Nov 15, 2022 | Insight for DBAs, PostgreSQL
In one of our previous posts—pgBackRest: A Great Backup Solution and a Wonderful Year of Growth—we discussed the installation of pgBackRest and the backup, quick restore command. It would be ideal to have a restoration activity scheduled as per business needs so that...
by Jobin Augustine | Nov 9, 2022 | Insight for DBAs, PostgreSQL
In the first part of the article, we discussed how to achieve minimum security by adding a username and password to Patroni REST API and switching from HTTP traffic to HTTPS. In this article, we will be covering how to secure REST APIs using certificate...
by Charly Batista | Nov 4, 2022 | Insight for DBAs, Insight for Developers, PostgreSQL
I was recently reading the PostgreSQL 15 release notes and stopped at “Allow unique constraints and indexes to treat NULL values as not distinct”. At first glance, it seems to be a minor change, but this feature may change many designs and make many lives a lot...
by Kai Wagner | Nov 2, 2022 | Insight for DBAs, Insight for Developers, PostgreSQL
I just became part of the PostgreSQL ecosystem and was really curious to get in touch with the community. What are the best ways to interact with a community? Mailing lists for sure, forums, chat channels, or if possible an in-person conference. So I checked the...
by Jobin Augustine | Nov 1, 2022 | Insight for DBAs, PostgreSQL
In recent years, Patroni emerged as the number one HA framework for PostgreSQL, currently with 5K stars in its git repository. We blogged about how some of the extraordinary capabilities of Patroni to solve problems like Logical Replication Slot Failover. One...
by Jobin Augustine | Oct 11, 2022 | Insight for DBAs, PostgreSQL
Recently I blogged about a significant improvement in PostgreSQL 15: PostgreSQL 15: Stats Collector Gone? What’s New? While there is great cheer for this upcoming improvement, we could see a few comments about “inefficiencies” in previous versions....
by Umair Shahid | Oct 6, 2022 | Database Trends, Insight for DBAs, PostgreSQL
After four beta releases and one Release Candidate, the RC2 for PostgreSQL 15 was announced earlier today. If all goes well – fingers crossed! – this release will be promoted to General Availability (or GA) on October 13. PostgreSQL Global Development...
by David Stokes | Sep 13, 2022 | Insight for DBAs, MySQL, PostgreSQL
First, a big thanks for the kind responses to this series, and, as requested, here is an overview of index types available in PostgreSQL. The supporting video with bonus material can be found here. PostgreSQL has several popular index types including B-tree, Hash,...
by Robert Bernier | Sep 13, 2022 | Insight for DBAs, Insight for Developers, PostgreSQL
One of the reasons I’ve never strayed far from PostgreSQL is that I am always discovering features that overcome all sorts of interesting problems. Although, to be honest, from time to time I’ve had the feeling that sometimes some features are a solution in...
by Robert Bernier | Sep 2, 2022 | Insight for DBAs, Insight for Developers, Open Source, PostgreSQL
After working with PostgreSQL for so many years it’s sometimes surprising to see some of the utilities, to a certain degree, have capabilities that remain relatively unknown to more than a few people. So let me introduce you to manifests. Both pg_dump and...
by David Stokes | Aug 29, 2022 | Insight for DBAs, MySQL, PostgreSQL
Those new to the realm of PostgreSQL from other databases will find little gems sprinkled liberally through the software. One of those gems is the watch command. It can be used to repeatedly run a query over and over again. Pretend you are watching the progress of...
by Jobin Augustine | Aug 26, 2022 | Insight for DBAs, PostgreSQL
Anyone trying the upcoming PostgreSQL 15 might observe that one of the background processes is missing. postgres 1710 1 0 04:03 ? 00:00:00 /usr/pgsql-15/bin/postmaster -D /var/lib/pgsql/15/data/ postgres 1711 1710 0 04:03 ? 00:00:00 postgres: logger postgres 1712 1710...
by David Stokes | Aug 18, 2022 | Insight for DBAs, MySQL, PostgreSQL
Thank you for the many kind responses to this series. There are many out there who have MySQL experience and are seeking to expand into PostgreSQL for reasons ranging from simple curiosity to fortifying their professional skills. Now that we have covered the...
by Jorge Torralba | Aug 5, 2022 | Insight for DBAs, PostgreSQL
I have been working with Postgres now for many years, most recently as a consultant at Percona for companies with new implementations of Postgres as a result of migrating from Oracle or some other legacy database engine. In some cases, these are Fortune 100 companies...
by David Gonzalez | Aug 4, 2022 | Benchmarks, Insight for DBAs, Insight for Developers, PostgreSQL
When working with databases, there are always some projects oriented to performing analytics and reporting tasks over the information stored in the database. Usually, these tasks leverage window functions to do calculations “across a set of table rows that are...
