Mon, 29 Apr 2024 16:18:09 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.2 https://www.percona.com/blog/wp-content/uploads/2023/02/cropped-percona-favicon-32x32.png 32 32 76301791 https://www.percona.com/blog/setting-up-streaming-replication-postgresql/ https://www.percona.com/blog/setting-up-streaming-replication-postgresql/#comments Thu, 01 Feb 2024 13:00:58 +0000 https://www.percona.com/blog/?p=52469 This blog was originally published in September 2018 and was updated in Feburary of 2024Configuring replication between two databases is considered to be the best strategy for achieving high availability during disasters and provides fault tolerance against unexpected failures. PostgreSQL satisfies this requirement through streaming replication. We shall talk about another option called logical replication […]]]> https://www.percona.com/blog/setting-up-streaming-replication-postgresql/feed/ 22 52469 https://www.percona.com/blog/postgresql-backup-strategy-enterprise-grade-environment/ https://www.percona.com/blog/postgresql-backup-strategy-enterprise-grade-environment/#comments Sun, 02 Jul 2023 17:13:16 +0000 https://www.percona.com/blog/?p=52811 This blog was originally written in September 2018 and was updated in June 2023.In this post, we cover the methods used to achieve an enterprise-grade backup strategy for the PostgreSQL cluster. In setting up our demonstration system, we use pg_basebackup and continuous archiving. The size of the database and your database environment—if it is on […]]]> https://www.percona.com/blog/postgresql-backup-strategy-enterprise-grade-environment/feed/ 6 52811 https://www.percona.com/blog/an-overview-of-sharding-in-postgresql-and-how-it-relates-to-mongodbs/ https://www.percona.com/blog/an-overview-of-sharding-in-postgresql-and-how-it-relates-to-mongodbs/#comments Tue, 24 Jan 2023 09:44:38 +0000 https://www.percona.com/blog/?p=57306 This post was originally published in 2019 and was updated in 2023.I presented at Percona University São Paulo about the new features in PostgreSQL that allow the deployment of simple shards. I’ve tried to summarize the main points in this post, as well as provide an introductory overview of sharding itself. Please note I haven’t […]]]> https://www.percona.com/blog/an-overview-of-sharding-in-postgresql-and-how-it-relates-to-mongodbs/feed/ 5 57306 https://www.percona.com/blog/using-security-definer-to-monitor-postgresql-9-6-or-earlier-using-percona-monitoring-and-management/ Tue, 22 Sep 2020 13:45:02 +0000 https://www.percona.com/blog/?p=64742 I have previously written a blog post on the detailed steps involved in enabling PostgreSQL monitoring using PMM. In that post, you could see me talking about the role: pg_monitor that can be granted to monitoring users. The [crayon-664c92b78194f660819903-i/] role restricts a monitoring user from accessing user data but only grants access to statistic views […]]]> 64742 https://www.percona.com/blog/postgresql-application-connection-failover-using-haproxy-with-xinetd/ Thu, 31 Oct 2019 15:00:35 +0000 https://www.percona.com/blog/?p=62934 Recently we published a blog about a very simple application failover using libpq features which could be the simplest of all automatic application connection routing.  In this blog post, we are discussing how a proxy server using HAProxy can be used for connection routing which is a well-known technique with very wide deployment. There are […]]]> 62934 https://www.percona.com/blog/monitoring-postgresql-databases-using-percona-monitoring-management/ https://www.percona.com/blog/monitoring-postgresql-databases-using-percona-monitoring-management/#comments Tue, 29 Oct 2019 18:16:04 +0000 https://www.percona.com/blog/?p=63019 PostgreSQL is a widely-used Open Source database and has been the DBMS of the year for the past 2 years in DB-Engine rankings. As such, there is always a need for reliable and robust monitoring solutions. While there are some commercial monitoring tools, there is an equally good number of open source tools available for […]]]> https://www.percona.com/blog/monitoring-postgresql-databases-using-percona-monitoring-management/feed/ 10 63019 https://www.percona.com/blog/seamless-application-failover-using-libpq-features-in-postgresql/ Wed, 23 Oct 2019 16:58:56 +0000 https://www.percona.com/blog/?p=62795 When you build replication in PostgreSQL using Streaming replication, you cannot perform writes to a standby node; only reads. This way, you could offload reads or reporting queries to standby servers and send writes to master. Additionally, starting from PostgreSQL 10, [crayon-664c92b78399c576913636-i/]  and [crayon-664c92b7839a1556758490-i/] clients could probe the connection for a master and allow connections […]]]> 62795 https://www.percona.com/blog/how-to-set-up-streaming-replication-in-postgresql-12/ https://www.percona.com/blog/how-to-set-up-streaming-replication-in-postgresql-12/#comments Fri, 11 Oct 2019 14:21:15 +0000 https://www.percona.com/blog/?p=62642 PostgreSQL 12 can be considered revolutionary considering the performance boost we observe with partitioning enhancements, planner improvements, several SQL features, Indexing improvements, etc. You may see some of such features discussed in future blog posts. But, let me start this blog with something interesting. You might have already seen some news that there is no […]]]> https://www.percona.com/blog/how-to-set-up-streaming-replication-in-postgresql-12/feed/ 10 62642 https://www.percona.com/blog/using-plpgsql_check-to-find-compilation-errors-and-profile-functions/ https://www.percona.com/blog/using-plpgsql_check-to-find-compilation-errors-and-profile-functions/#comments Tue, 30 Jul 2019 18:02:26 +0000 https://www.percona.com/blog/?p=58721 There is always a need for profiling tools in databases for admins or developers. While it is easy to understand the point where an SQL is spending more time using [crayon-664c92b78523e799069011-i/] or [crayon-664c92b785243243357146-i/] in PostgreSQL, the same would not work for functions. Recently, Jobin has published a blog post where he demonstrated how plprofiler can […]]]> https://www.percona.com/blog/using-plpgsql_check-to-find-compilation-errors-and-profile-functions/feed/ 2 58721 https://www.percona.com/blog/automatic-index-recommendations-in-postgresql-using-pg_qualstats-and-hypopg/ https://www.percona.com/blog/automatic-index-recommendations-in-postgresql-using-pg_qualstats-and-hypopg/#comments Mon, 22 Jul 2019 16:13:59 +0000 https://www.percona.com/blog/?p=58654 In my previous blog post, we have seen how the extension hypopg can be helpful in creating hypothetical indexes in PostgreSQL. If you have read it already, you know that it is very useful in verifying whether an Index can improve the performance of an SQL without having to create it in reality. Considering this, […]]]> https://www.percona.com/blog/automatic-index-recommendations-in-postgresql-using-pg_qualstats-and-hypopg/feed/ 10 58654 https://www.percona.com/blog/hypothetical-indexes-in-postgresql/ https://www.percona.com/blog/hypothetical-indexes-in-postgresql/#comments Fri, 21 Jun 2019 18:02:17 +0000 https://www.percona.com/blog/?p=57848 At recent conferences, we have received a curious question from users who have used Oracle in the past and are now using PostgreSQL: “Do we have hypothetical indexes in PostgreSQL ?“. The answer to that question is YES. The true meaning of hypothetical is imaginary but not real. We can try creating indexes that are […]]]> https://www.percona.com/blog/hypothetical-indexes-in-postgresql/feed/ 1 57848 https://www.percona.com/blog/bloom-indexes-in-postgresql/ https://www.percona.com/blog/bloom-indexes-in-postgresql/#comments Fri, 14 Jun 2019 19:29:56 +0000 https://www.percona.com/blog/?p=57725 There is a wide variety of indexes available in PostgreSQL. While most are common in almost all databases, there are some types of indexes that are more specific to PostgreSQL. For example, GIN indexes are helpful to speed up the search for element values within documents. GIN and GiST indexes could both be used for […]]]> https://www.percona.com/blog/bloom-indexes-in-postgresql/feed/ 3 57725 https://www.percona.com/blog/postgresql-minor-versions-released-may-9-2019/ https://www.percona.com/blog/postgresql-minor-versions-released-may-9-2019/#comments Mon, 13 May 2019 16:13:52 +0000 https://www.percona.com/blog/?p=57118 Usually, the PostgreSQL Community releases minor patches on the Thursday of the second week of the second month of each quarter. This can vary depending on the nature of the fixes. For example, if the fixes include critical fixes as a postgres community response to security vulnerabilities or bugs that might affect data integrity. The […]]]> https://www.percona.com/blog/postgresql-minor-versions-released-may-9-2019/feed/ 1 57118 https://www.percona.com/blog/upgrading-migrating-legacy-postgresql/ Fri, 26 Apr 2019 13:00:10 +0000 https://www.percona.com/blog/?p=56633 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 built-in as well as open source tools.Watch the Recorded WebinarTo start, this webinar opens with a list of […]]]> 56633 https://www.percona.com/blog/fast-upgrade-of-legacy-postgresql-with-minimum-downtime-using-pg_upgrade/ https://www.percona.com/blog/fast-upgrade-of-legacy-postgresql-with-minimum-downtime-using-pg_upgrade/#comments Fri, 12 Apr 2019 15:44:44 +0000 https://www.percona.com/blog/?p=56295 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 pg_upgrade allows you, potentially, to minimize your downtime, an essential consideration […]]]> https://www.percona.com/blog/fast-upgrade-of-legacy-postgresql-with-minimum-downtime-using-pg_upgrade/feed/ 7 56295 https://www.percona.com/blog/replication-between-postgresql-versions-using-logical-replication/ https://www.percona.com/blog/replication-between-postgresql-versions-using-logical-replication/#comments Thu, 04 Apr 2019 17:21:11 +0000 https://www.percona.com/blog/?p=56174 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 means of upgrade, and depending on your scenario, you can choose […]]]> https://www.percona.com/blog/replication-between-postgresql-versions-using-logical-replication/feed/ 4 56174 https://www.percona.com/blog/postgresql-upgrade-using-pg_dump-pg_restore/ https://www.percona.com/blog/postgresql-upgrade-using-pg_dump-pg_restore/#comments Wed, 27 Mar 2019 18:09:33 +0000 https://www.percona.com/blog/?p=56089 In this blog post, we will explore  [crayon-664c92b78a4ce849714899-i/] / [crayon-664c92b78a4d4260234635-i/], one of the most commonly used options for performing a PostgreSQL upgrade. It is important to understand the scenarios under which [crayon-664c92b78a4d6607201422-i/] and [crayon-664c92b78a4d7279342765-i/] utilities will be helpful.This post is the second of our Upgrading or Migrating Your Legacy PostgreSQL to Newer PostgreSQL Versions series […]]]> https://www.percona.com/blog/postgresql-upgrade-using-pg_dump-pg_restore/feed/ 3 56089 https://www.percona.com/blog/postgresql-upgrade-using-pg_dumpall/ Mon, 18 Mar 2019 14:59:50 +0000 https://www.percona.com/blog/?p=55856 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 upgrading a cluster too. We consider the advantages […]]]> 55856 https://www.percona.com/blog/postgresql-webinar-wed-april-17-upgrading-migrating-legacy-postgresql-newer-versions/ https://www.percona.com/blog/postgresql-webinar-wed-april-17-upgrading-migrating-legacy-postgresql-newer-versions/#comments Mon, 04 Mar 2019 14:34:52 +0000 https://www.percona.com/blog/?p=55705 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 demonstrate the upgrade of a legacy version of PostgreSQL to a newer version, using built-in as well as […]]]> https://www.percona.com/blog/postgresql-webinar-wed-april-17-upgrading-migrating-legacy-postgresql-newer-versions/feed/ 1 55705 https://www.percona.com/blog/postgresql-fsync-failure-fixed-minor-versions-released-feb-14-2019/ https://www.percona.com/blog/postgresql-fsync-failure-fixed-minor-versions-released-feb-14-2019/#comments Fri, 22 Feb 2019 13:47:27 +0000 https://www.percona.com/blog/?p=55375 In case you didn’t already see this news, PostgreSQL has got its first minor version released for 2019. This includes minor version updates for all supported PostgreSQL versions. We have indicated in our previous blog post that PostgreSQL 9.3 had gone EOL, and it would not support any more updates. This release includes the following […]]]> https://www.percona.com/blog/postgresql-fsync-failure-fixed-minor-versions-released-feb-14-2019/feed/ 2 55375