BE SHARING

PostegreSQL

PostgreSQL Cluster using repmgr

11.08.2022 by Karsten Lenz

With this blog I describe the installation of a PostgreSQL Cluster using repmgr instead of Patroni. Repmgr was originally developed by 2ndQuadrant which is now part of EDB and EDB decided for the 2ndQuadrant tools for the future, barman as(…)

Database Administration & Monitoring

How to scale up a Patroni cluster

06.11.2019 by Gérard Wisson

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(…)

PostgreSQL

pgconf.eu – Welcome to the community

18.10.2019 by Gérard Wisson

On tuesday I started my journey to Milan to attend my first pgconf.eu, which was also my first big conference. I was really excited what will come up to me. How will it be, to become a visible part of(…)

Database Administration & Monitoring

EDB EPAS 12 comes with interval partitioning

10.08.2019 by Daniel Westermann

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(…)

Database Administration & Monitoring

Deploying EDB containers in MiniShift/OpenShift

11.05.2018 by Daniel Westermann

This blog refers to an older version of EDB's Postgres on Kubernetes offering that is no longer available. In this post we'll look at how we can deploy EnterpriseDB containers in MiniShift. When you need to(…)

Database Administration & Monitoring

PgBackRest : Dedicated Backup Host

01.04.2018 by Oracle Team

By Mouhamadou Diaw 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(…)

Database Administration & Monitoring

PostgreSQL 11: Procedures and transaction control

20.03.2018 by Daniel Westermann

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(…)

Database Administration & Monitoring

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

02.04.2017 by Daniel Westermann

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(…)

Database Administration & Monitoring

Temporal tables with PostgreSQL

27.01.2017 by Oracle Team

By Mouhamadou Diaw 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(…)

Database Administration & Monitoring

EDB Postgres Advanced Server 9.6 BETA released

08.11.2016 by Daniel Westermann

Yesterday EnterpriseDB released the beta of the next version of Postgres Advanced Server. You can sign up for the beta program here and download the software here.