High Availability in PostgreSQL

2022-08-24
blank

A 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 more

What awaits us in PostgreSQL 15?

2022-07-20
blank

After nearly 9 months since the creation of PostgreSQL 14, the developers of the popular database engine have decided to release PostgreSQL 15 beta version. In this article we will take a closer look at what waits for us in PostgreSQL 15 – one of the most popular open source object-relational database management systems.

Read more

Logical replication in PostgreSQL using pglogical – tutorial

2022-03-08
blank

Databases 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 more

Underneath PostgreSQL 14 – a detailed list of changes

2021-11-10
blank

We 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 more