High Availability in PostgreSQL on the example of EuroDB

24.08.2022 / Database
High Availability in PostgreSQL on the example of EuroDB
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.

What awaits us in PostgreSQL 15?

20.07.2022 / Database
PostgreSQL 15 Beta
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.

Generating sample data in PostgreSQL with EuroDB tools

08.06.2022 / Database
Generating sample data in PostgreSQL with EuroDB tools
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.

Migrating relational databases to PostgreSQL using EuroDB tools

13.04.2022 / Database
Migrating relational databases to PostgreSQL using EuroDB tools
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.

PostgreSQL database back up with the use of EuroDB tools

06.04.2022 / Database
PostgreSQL database back up with the use of EuroDB tools
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.

Logical replication of PostgreSQL database with EuroDB tools

08.03.2022 / Database
Logical replication of PostgreSQL database with EuroDB tools
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.

Analysis of statistics in PostgreSQL database using EuroDB tools

15.02.2022 / Database
Analysis of statistics in PostgreSQL database using EuroDB tools
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.

Analysis of logs in PostgreSQL using EuroDB tools

24.11.2021 / Database
EuroLinux analysis of logs in PostgreSQL using EuroDB tools
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.

Underneath PostgreSQL 14 – a detailed list of changes

10.11.2021 / Database
EuroLinux PostgreSQL 14 list of changes
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.