An Overview of Trusted Extensions in PostgreSQL 13
In my previous blog, we explored new capabilities of Logical replication with Partition tables in PostgreSQL 13. Needless to say that there are multitude of such features in the mentioned release which will soon enhance...
My Favorite PostgreSQL Extensions – Part Two
This is the second part of my blog “My Favorite PostgreSQL Extensions” wherein I had introduced you to two PostgreSQL extensions, postgres_fdw and pg_partman. In this part I will explore three more. pgAudit The next...
My Favorite PostgreSQL Extensions – Part One
This is in continuation of my previous blog entry wherein I had touched upon a topic of PostgreSQL Extensions. PostgreSQL Extensions are a plug and play set of enhancements that add an extra feature-set to...
How to Enable TimescaleDB on an Existing PostgreSQL Database
If you have a PostgreSQL cluster up-and-running, and you need to handle data that changes with time (like metrics collected from a system) you should consider using a time-series database that is designed to store...
Creating New Modules using PostgreSQL Create Extension
Introduction As you may know, PostgreSQL is designed for extensibility and customization, this means that we can extend the functionality of your database using extensions. PostgreSQL extension functionality allows for bundling multiple SQL objects...