by Jobin Augustine | May 10, 2019 | Insight for DBAs, PostgreSQL
pgBackRest addresses many of the must-have features that you’ll want to look for in a PostgreSQL backup solution. I have been a great fan of the pgBackRest project for quite some time, and it gets better all the time. Historically, it was written in perl and now... by Jobin Augustine | Apr 26, 2019 | Insight for DBAs, PostgreSQL, Webinars
Please join Percona’s PostgreSQL Support Technical Lead, Avinash Vallarapu and Senior Support Engineers, Fernando Laudares, Jobin Augustine and Nickolay Ihalainen as they demonstrate the methods to upgrade a legacy version of PostgreSQL to a newer version using... by Jobin Augustine | Apr 12, 2019 | PostgreSQL
When you need to upgrade your PostgreSQL databases, there are a number of options available to you. In this post we’ll take a look at how you can upgrade PostgreSQL versions using pg_upgrade, a built-in tool that allows in-place upgrade of your software. Using... by Jobin Augustine | Apr 4, 2019 | PostgreSQL
When you need to upgrade PostgreSQL, there are a variety of approaches that you can use. To avoid application downtime, then not all of the options to upgrade postgres are suitable. When avoiding downtime is essential, then you might consider using replication as a... by Jobin Augustine | Mar 27, 2019 | PostgreSQL
In this blog post, we will explore pg_dump / pg_restore, one of the most commonly used options for performing a PostgreSQL upgrade. It is important to understand the scenarios under which pg_dump and pg_restore utilities will be helpful.This post is the second... by Jobin Augustine | Mar 18, 2019 | PostgreSQL
There are several approaches to assess when you need to upgrade PostgreSQL. In this blog post, we look at the option for upgrading a postgres database using pg_dumpall. As this tool can also be used to back up PostgreSQL clusters, then it is a valid option for... by Jobin Augustine | Mar 4, 2019 | PostgreSQL
A date for your diary. On Wednesday, April 17 at 7:00 AM PDT (UTC-7) / 10:00 AM EDT (UTC-4) Percona’s PostgreSQL Support Technical Lead, Avinash Vallarapu and Senior Support Engineers, Fernando Laudares, Jobin Augustine and Nickolay Ihalainen, will... by Jobin Augustine | Feb 13, 2019 | Insight for DBAs, PostgreSQL
PostgreSQL is emerging as the standard destination for database migrations from proprietary databases. As a consequence, there is an increase in demand for database side code migration and associated performance troubleshooting. One might be able to trace the latency... by Jobin Augustine | Nov 19, 2018 | Insight for DBAs, Insight for Developers, PostgreSQL
Just-in-time (JIT in PostgreSQL) compilation of SQL statements is one of the highlighted features in PostgreSQL 11. There is great excitement in the community because of the many claims of up to a 30% jump in performance. Not all queries and workloads... by Jobin Augustine | Oct 19, 2018 | PostgreSQL, Webinars
Hello everyone, and thank you to those that attended our webinar on Building an Enterprise-grade PostgreSQL setup using open source tools last Wednesday. You’ll find the recordings of such as well as the slides we have used during our presentation here.We had... by Jobin Augustine | Oct 18, 2018 | Insight for DBAs, Insight for Developers, PostgreSQL
You may be aware that the new major version of PostgreSQL has been released today. PostgreSQL 11 is going to be one of the most vibrant releases in recent times. It incorporates many features found in proprietary, industry-leading database systems, further qualifying... by Jobin Augustine | Oct 9, 2018 | Monitoring, Percona Software, PostgreSQL, Webinars
This is the last post in our series on building an enterprise-grade PostgreSQL set up using open source tools, and we’ll be covering monitoring.The previous posts in this series discussed aspects such as security, backup strategy, high... by Jobin Augustine | Oct 8, 2018 | Insight for DBAs, Insight for Developers, PostgreSQL
In this penultimate post from our series on building an enterprise-grade PostgreSQL environment we cover the parameters we have enabled to configure detailed logging in the demo setup we will showcase in our upcoming webinar. Detailed logging in PostgreSQL and... by Jobin Augustine | Oct 5, 2018 | Insight for DBAs, Insight for Developers, PostgreSQL
In this current series of blog posts, we have been discussing various relevant aspects when building an enterprise-grade PostgreSQL setup, such as security, back up strategy, high availability, and different methods to scale PostgreSQL. In this blog post, we’ll... by Jobin Augustine | Oct 2, 2018 | Insight for DBAs, Insight for Developers, PostgreSQL
In the previous blog posts in this series, we’ve covered some of the essential aspects of an Enterprise-grade solution: security, high availability, and backups. Another important aspect is the scalability of the solution: as our application grows how do we... by Jobin Augustine | Sep 28, 2018 | Insight for DBAs, Insight for Developers, PostgreSQL
High availability (HA) and database replication is a major topic of discussion for database technologists. There are a number of informed choices to be made to optimize PostgreSQL replication so that you achieve HA. In this post we introduce an overview of the topic,... by Jobin Augustine | Sep 21, 2018 | Insight for DBAs, Insight for Developers, Percona Events, PostgreSQL, Security
In this post, we review how you can build an enhanced and secure PostgreSQL database environment using community software. We look at the features that are available in PostgreSQL that, when implemented, provide improved security.As discussed in the introductory blog... by Jobin Augustine | Sep 14, 2018 | Insight for DBAs, Insight for Developers, PostgreSQL, Webinars
Please join Percona’s PostgreSQL Support Technical Lead, Avinash Vallarapu; Senior Support Engineer, Fernando Laudares; and Senior Support Engineer, Jobin Augustine, on Wednesday, October 10th, 2018 at 7:00 AM PDT (UTC-7) / 10:00 AM EDT (UTC-4), as they... by Jobin Augustine | Aug 24, 2018 | MySQL, PostgreSQL
There are many organizations where front/web-facing applications use MySQL and back end processing uses PostgreSQL®. Any system integration between these applications generally involves the replication—or duplication—of data from system to system. We... by Jobin Augustine | Aug 21, 2018 | Open Source, PostgreSQL
There are a few features in PostgreSQL that are very compelling, and that I rarely see in other RDBMSs. Some of these features are the driving force behind the growing popularity of PostgreSQL. This blog post is about one of my favorite features: FDW (Foreign Data...