On October 13, 2022, the PostgreSQL Global Development Group team released the latest version of the highly anticipated PostgreSQL 15 database engine, so it's a good opportunity to get a closer look at the freshest product, comparing it to the previous version.
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.
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.
Random data generation is one of the most important features of databases used in companies. It is used on various technical as well as business levels. It provides an opportunity for secure testing of databases and helps to develop competence in database administration.
A lot of applications allow the use of different database engines. It is therefore possible that the decision to choose a particular engine was made too hastily or the requirements for the application itself have changed. An important recommendation to change the engine may also be the high license costs of the existing database solution. In these cases, database migration becomes the best solution. Today we will introduce the topic of migration, its security and simplicity – using the solutions offered by the tools from EuroDB.
There are two kinds of people: those who create back up copies and those who will start creating them. In today's article, we will take a closer look at the concept of backup and perform basic configuration of the backup database using the EuroDB backup tool.
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 with a module that is part of the EuroDB database platform.
Database monitoring is very often underestimated by developers. It is often pushed into the background, even though it is one of the simplest and most effective tools for maintaining and optimizing a database and finding errors in it. Therefore, today we'll follow up on that topic and take a closer look at analyzing statistics in a PostgreSQL database.
Traditional log analysis is usually a tedious and tiring process. Can't it be pleasing and eye-friendly? Today's topic will be the log analysis module, one of the tools offered in EuroDB, which greatly facilitates the work with logs.
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.
What 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.