Great news for Postgres fans. The latest version of the PostgreSQL database is now available. It offers state-of-the-art security and stability standards. In this article, we’ll lean into the changes in PostgreSQL 15.2.
Read more
An upgrade should be a standard activity of every database administrator. It is recommended if you want to take advantage of new functionality or improve database performance. Therefore, in today’s article we will talk about upgrading versions of database systems like PostgreSQL.
Read moreAt the end of 2022, we received a series of new updates from the Postgres team that improve the quality and security of our databases. In this article we will take a closer look at the latest PostgreSQL patches, list the versions that received patches, for which this is the last official patch. We invite you to read on.
Read moreA standard High Availability system should be available 99.999% of the time – it can have 5 minutes and 15.6 seconds of downtime per year. Because of the number of nines, it is called “five nines.” However, there are “six nines” or “seven nines” systems. In this article, we will take a closer look at HA and discuss the types of high availability system architectures in PostgreSQL.
Read moreDatabases are what is the most often the critical component of any enterprise. Therefore, in order to ensure high availability, replication mechanisms have been created. Today we will introduce the topic of logical replication in PostgreSQL 13. The process of copying and transferring information between servers and keeping them synchronized in order to maintain consistency […]
Read moreWe prepared the broadest overlook on the changes and new functionalities. PostgreSQL is an object-relational database management system, developed at the University of California at Berkeley Computer Science Department. With over two decades of development behind it, PostgreSQL is now the most advanced open-source database available anywhere.
Read moreMany people suffer from the irrational fear of 13, which is professionally referred to as triskaidecaphobia. In the case of the latest PostgreSQL release, bearing this number, however, the concerns are unfounded. Almost everyone will find changes that improve Postgres’s everyday aspects. So let’s try „conjure up ” apparent unluckyness of the 13th PostgreSQL release. […]
Read moreWhat are the benefits of database proxy? How does a proxy relate to high-availability solutions? Can a connection pooler offer any new possibilities? In this instalment of the series on creating reliable replicated PostgreSQL clusters, I will try to answer the above questions.
Read more