As discussed on the Postgres Backup for Peeps blog, here are the basic steps to install and configure pgBackRest for backing up a production PostgreSQL server: PgBackRest Installation:[root@localhost ~]# yum install pgbackrest[root@localhost ~]# pgbackrest versionpgBackRest 2.45 Change Parameters on postgresql.conf … Read More
Opensource DB BLOG
Setting up and Configuring pgBarman
As discussed on the Postgres Backup for Peeps blog, here are the basic steps to install and configure Barman for backing up a production PostgreSQL server: S.No Hostname IP Role 1 Node1 192.168.113.155 Barman Server (Backup Server) 2 Node2 192.168.113.156 … Read More
Unveiling the mystery of Postgres Backups for my peeps
Introduction When it comes to backing up PostgreSQL databases, there are several tools available. Three popular ones are pg_basebackup, pgBarman, and pgBackRest. While they all serve the same purpose, they have some significant differences that can impact your backup strategy. … Read More
Six Strategies for Improving Customer Experience (CX) & Customer Success (CS)
Why is Customer Success your golden ticket to business success? In the last post, I shared my interest and learning experience on PostgreSQL. In this blog, I will share more details on Why Customer Success is crucial for any business. … Read More
Face-to-face Event Creates a Global Impact
I recently attended my first tech conference, and here I’ll talk about my experience and takeaways. In conferences like this, we would of course be very excited to witness the presentations from well-established professionals who know their stuff; but in … Read More
Why did I choose Postgres career and how I made it my best decision ever?
Well, just to set the groundwork before going gaga over PostgreSQL, in my previous avatar I was a Data Analyst, Program Manager dealing with creating business through approaching new and existing clients and providing a good customer experience. However, I … Read More
Safer Internet Day – The Postgres Way
The Internet is not a SAFE place. PERIOD!Well, YOU can make it Safer! At OpenSource DB, we took the standard DBA processes and turned them into Safe & Best practices. Read on to know more: Below are some processes that … Read More
pg_backend_memory_contexts
I have always been curious to look at a certain Postgres backend connection’s memory consumption. With this new pg_backend_memory_contexts view, we can now take a closer look at how much of memory is exactly allocated for a given Postgres backend … Read More
An intern’s View of PostgreSQL
About Postgres (the What) PostgreSQL is a powerful open source RDBMS . It has gained a strong confidence for reliability , data integrity and correctness . It is known as the most advanced open source database system. It runs on … Read More
Fetch parameters & metadata datatype of Procedure/Function
In an interesting discussion with one of our Customers’ Development team, a question came up: “Do you have a query to get the list of input/output parameters in the defined sequence for a given procedure/function?” Obviously, we did two things … Read More
PostgreSQL 15 New Features (Part – 2)
This year, PostgreSQL’s major upgrade, pg15 was released on 13th October 2022. Here, we examine some more of the new features that were incorporated into release pg15. If you have not reviewed Part – 1 of this series, you can … Read More
PostgreSQL 15 New Features (Part – 1)
This year, PostgreSQL’s major upgrade, pg15 was released on 13th October 2022. Here, we examine some of the new features that were incorporated into release pg15. To make things easier, we’ve categorized the new features into two parts: Part – … Read More
Running PostgreSQL 9.6? Time for a major upgrade!
In the last blog post, we mentioned the latest PostgreSQL Minor release of PostgreSQL 14.1, 13.5, 12.9, 11.14, 10.19, and 9.6.24. An important note is that this is the final release of the PostgreSQL 9.6 major version. The PostgreSQL Global … Read More
PostgreSQL Minor release – Nov 2021
PostgreSQL 14.1, 13.5, 12.9, 11.14, 10.19, and 9.6.24 Released! The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 14.1, 13.5, 12.9, 11.14, 10.19, and 9.6.24. This release closes two security vulnerabilities … Read More
PostgreSQL 14 New Features – Cool little things
I will be honest with this – I wasn’t sure about doing 100% justice to the 9-days & 9-part blog series to commemorate one of the biggest Festivals in India – Navratri Well, today, it’s a Wrap-up of the PostgreSQL … Read More
PostgreSQL 14 New Features – Developer boons
After the previous blog post on PostgreSQL 14 New features for DBAs, I am here to present a few interesting Developer centric new features with this post. Improved Data types Multirange datatypes Multiranges are basically sorted arrays of non-overlapping ranges … Read More
PostgreSQL 14 New Features – DBA Lifesavers
We have covered a considerable amount of PostgreSQL 14 features in our previous posts, they are: Performance enhancements Monitoring improvements New configuration parameters introduced Security Well, today is going to be a fun ride – New DBA Features in PG14, … Read More
PostgreSQL 14 New Features – Security
Database security refers to the collective measures used to protect and secure a database or database management software from illegitimate use and malicious cyber threats and attacks. Database security procedures are aimed at protecting not just the data inside the … Read More
PostgreSQL 14 New Features – Monitoring improvements
Database Monitoring, Database Availability, Data Observability, Data Lineage, Data Provenance… Wow! way too many things. As a Database Engineer, database monitoring is the utmost important aspect for any database shop, it lays the foundation of the whole platform. So, I … Read More
PostgreSQL 14 New Features – Conf params introduced
This 9-part Blog series is getting interesting day by day. Yesterday, we concluded our part of the blog about some of the interesting Performance enhancements around System-level, Data handling & modifications, and Workload specific features introduced in PostgreSQL 14. Today, … Read More
PostgreSQL 14 New Features – Part 3
This is the third installment of 9-part Blog series talking about some of the PostgreSQL 14 New features. In the first part and second parts, we discussed a few of the important System-level & Data handling performance enhancements introduced in the PostgreSQL … Read More
PostgreSQL 14 New Features – Part 2
This is the second installment of 9-part Blog series talking about some of the PostgreSQL 14 New features. In the first part, we discussed a few of the important System-level performance enhancements introduced in the PostgreSQL 14 major version. Mind you, … Read More
PostgreSQL 14 New Features – Blog series – Part 1
Alone, We can do so little; Together, We can do so much – Helen Keller PostgreSQL is a powerful, open-source object-relational database system with over 30 years of active development that has earned it a strong reputation for reliability, feature … Read More
Yaaaay! Welcoming PostgreSQL 14…
Continuous improvement is better than delayed perfection – Mark Twain (one of my favorite quotes from the All-time greatest writers) The PostgreSQL Global Development Group today announced the release of PostgreSQL 14, the latest version of the world’s most advanced … Read More