Infrastructure at your Service

Tag

PostgreSQL Archives - Blog dbi services

Daniel Westermann

New options for pg_basebackup in PostgreSQL 15

By | Database Administration & Monitoring | No Comments

If, and you should, are doing base backups of your PostgreSQL instances you’ve probably used pg_basebackup. Another use case for pg_basebackup is to create a starting point for replicas when you are setting up streaming replication. Up to now, pg_basebackup will send the result always to the node/machine where you started it. That means: If you started pg_basebackup on your client or backup machine, then the resulting base backup will go there. No other options…

Read More
Karsten Lenz

PostgreSQL on ARM using Odroid N2/N2+

By | Database Administration & Monitoring | No Comments

For this installation i’m using a Hardkernel Odroid N2/N2+ which are ARM S922X, means ARM Big Little Architecture with Quad-Core-ARM-Cortex-A73-CPU-Cluster and a Dual-Core-Cortex-A53-Cluster and a Mali-G52-GPU. These device is normaly a good device as Mediaplayer using Coreelec based on Kodi, it has everything needed for including IR receiver for IR remote device. The installation of ARMBIAN is a easy step, Odroid N2 devices using a EMMC Module and with a Adapter for SD Cards it…

Read More
Daniel Westermann

Open source monitoring solutions (2) – Zabbix agents and PostgreSQL monitoring

By | Database Administration & Monitoring | No Comments

By the end of the last post we finished with a running Zabbix server which uses PostgreSQL as it’s back-end database. In addition a Zabbix agent is running on the same host, so the monitoring host itself is present in the Zabbix console. In this post will deploy the Zabbix agent on three PostgreSQL Patroni nodes and later on configure Zabbix to monitor the PostgreSQL instances.

Read More
Daniel Westermann

PostgresBuild2021 – questions feedback (1)

By | Database Administration & Monitoring | 2 Comments

PostgresBuild2021 is currently ongoing and as usual, I had questions after my talk I could not immediately answer. One of the best ways to learn, is to present a topic. There are for sure questions you never thought about. The topic of my talk was “An introduction to server side programming” and I wanted to give people easy examples about how to write procedures and functions in PostgreSQL. It was not about control structures like…

Read More
Daniel Westermann

Open source monitoring solutions (1) – Zabbix server setup

By | Database Administration & Monitoring | No Comments

We are often asked which monitoring solution we recommend for PostgreSQL, by people attending our PostgreSQL workshops. We usually answer: What do you have in place already? If a solution already is in place, the most obvious way is trying to integrate into the existing solution. If nothing is there already, you have plenty of choices. You can find some of them on this blog, but the list is quite old. Usually, PostgreSQL is not…

Read More
Daniel Westermann

Using pgBackRest to backup your PostgreSQL instances to a s3 compatible storage

By | Database Administration & Monitoring | No Comments

When it comes to backup and restore of PostgreSQL we usually recommend pgBackRest to our customers. This tool comes with many options and features and should bring everything you need. Most of the times we install a dedicated backup host for pgBackRest, which centralizes all backups of the PostgreSQL instances. Sometimes we have several of those, e.g. one for production instances, another for test and development or even a dedicated one for development. How you…

Read More
Daniel Westermann

Minor PostgreSQL version upgrades in a Patroni cluster

By | Database Administration & Monitoring | No Comments

Last week PostgreSQL 14.1, and all other minor versions for the supported version of PostgreSQL have been released. As usual, it is highly recommended to update to the latest minor release as soon as possible. Minor version updates of PostgreSQL are just a matter of installing the new binaries, shutting down the old cluster and starting it up again using the new binaries, that’s it. If you are using packages the procedure is to shutdown…

Read More
Daniel Westermann

PostgreSQL 15: read some options for pg_dump from a file

By | Database Administration & Monitoring | No Comments

PostgreSQL 15 will probably come with a new feature for pg_dump: Instead of passing the arguments/options directly to pg_dump when it is executed, you may also use a file to describe what you want to export. In the Oracle world it was (maybe still is, but I don’t know) very popular to do that with traditional exp/imp and the expdp/impdp utilities. pg_dump did not know that feature but this will probably change for PostgreSQL 15….

Read More
Daniel Westermann

Why does my first tablespace in PostgreSQL always get the OID 16384?

By | Database Administration & Monitoring | No Comments

For those already familiar with this topic and wonder about the heading, hold on and continue reading. One of the exercises we do in our PostgreSQL DBA Essentials workshop is to create a tablespace. This is to demonstrate how tablespaces work in PostgreSQL and, especially to show the symbolic link that gets created in $PGDATA/pg_tblspc. In one of the last workshops, two attendees noticed that they got the same OID and asked if that is…

Read More