Infrastructure at your Service

Tag

PostegreSQL Archives - Blog dbi services

Julia Gugel

How to scale up a Patroni cluster

By | Database Administration & Monitoring | No Comments

During the preparation of my presentation for the pgconf.eu I ran into one big issue. I had to stop my cluster to add a new node. That was not the way I wanted to archive this. I want a high availability solution, that can be scaled up without any outage. Due to a little hint during the pgconf.eu I was able to find a solution. In this post I will show the manually scale up,…

Read More
Daniel Westermann

EDB EPAS 12 comes with interval partitioning

By | Database Administration & Monitoring | No Comments

While community PostgreSQL 12 is in beta quite some time now (currently in beta 3) it usually takes some time until EDB EPAS will be available on top of the next major PostgreSQL release. Yesterday EDB finally released a beta and you can register for access here, release notes here. One of the new features is interval partitioning which you already might know from Oracle. Basically you do not need to create range partitions in…

Read More
Mouhamadou Diaw

PgBackRest : Dedicated Backup Host

By | Database Administration & Monitoring | No Comments

In previous blogs (blog1 and blog2) we saw a configuration of PgBackRest where the tool is installed in the same server that also hosts the PostgreSQL cluster. This configuration is fine if we have a single database server. But in the case that we have many database servers, it is more suitable to have a dedicated server for backups. This will also separate the backups and WAL archive from databases server In this article we…

Read More
Daniel Westermann

PostgreSQL 11: Procedures and transaction control

By | Database Administration & Monitoring | No Comments

Up to PostgreSQL 10 it was not possible to create procedures in PostgreSQL. Of course you can create functions which do not return anything but the possibility to create a procedure was not there. That will probably change in PostgreSQL 11 when nothing happens which will lead to the removal of that commit. On top of that there was another commit which enables transaction control inside procedures which can be quite interesting. Lets see how…

Read More
Daniel Westermann

Can I do it with PostgreSQL? – 13 – create database

By | Database Administration & Monitoring | No Comments

Following the last post about which tools you can use to create your PostgreSQL instance in this post we’ll look at how you can do the “create database” part that you would do in Oracle when not using the database configuration assistant. Of course can can create a database in PostgreSQL but it is not the same as it is in Oracle. To actually create your Oracle database you would do something like this once…

Read More
Mouhamadou Diaw

Temporal tables with PostgreSQL

By | Database Administration & Monitoring | 2 Comments

In this blog we are going to talk about a nice extension in PostgreSQL: temporal_tables. This extension provides support for temporal tables. What is a temporal table? Just a table that tracks the period of validity of a row. When implemented, this feature allows you to specify that old rows are archived into another table (that is called the history table). This can be useful for many purposes -Audit -Comparison -Checking table state in the…

Read More
Mouhamadou Diaw

Sharding with PostgreSQL

By | Database Administration & Monitoring | 9 Comments

In this article we are going to talk about sharding in PostgreSQL. What is sharding, Sharding is like partitioning. The difference is that with traditional partioning, partitions are stored in the same database while sharding shards (partitions) are stored in different servers. Below is an example of sharding configuration we will use for our demonstration PostgreSQL does not provide built-in tool for sharding. We will use citus  which extends PostgreSQL capability to do sharding and…

Read More