Infrastructure at your Service

Tag

PostgreSQL Archives - Blog dbi services

Franck Pachot

What is a database backup (back to the basics)

By | Database Administration & Monitoring, Postgres | No Comments

By Franck Pachot . TL;DR: do not consider a dump (like PostgreSQL pg_dump or Oracle expdp) as a database backup do not consider that your backup is successful if you didn’t test recovery databases provide physical database backups, easy and safe to restore and recover to any point-in-time between first backup and point of failure managed databases provide an easy recovery interface, but don’t trust it before you try it and… I’ve written this after…

Read More
Daniel Westermann

Getting started with Exasol – Some words about indexes and transactions

By | Database Administration & Monitoring | No Comments

If you followed Getting started with Exasol – Setting up an environment and Getting started with Exasol – Loading data from PostgreSQL you should have an Exasol test system up and running and a virtual schema pointing to a PostgreSQL schema. What we’ll be doing in this post is to load the data from PostgreSQL into Exasol and then have a look at how transactions work in Exasol and how Exasol is handling indexes.

Read More
Karsten Lenz

Azure Database for PostgreSQL

By | Database Administration & Monitoring | No Comments

This Blog is about some findings on Microsoft’s Azure service for PostgreSQL which I think needed to be noted. Findings about the infrastructure The Microsoft Azure Service for PostgreSQL is using Windows as OS Infrastructure, there are several points where it is possible to find out the used OS on PostgreSQL Level. select version(); => PostgreSQL 11.6, compiled by Visual C++ build 1800, 64-bi show dynamic_shared_memory_type; => windows show archive_command; => c:\postgres\bin\xlogcopy\xlogcopy.exe archive blob “%f”…

Read More
Daniel Westermann

PostgreSQL 13: Trusted extensions

By | Database Administration & Monitoring | No Comments

PostgreSQL 13 is just around the corner and one little, but important feature that was added are trusted extensions. When you want to add an extension to a database you need to be superuser for most of the extension or you need to implement something like this (please also note the comment from Hans at the bottom of the blog). This is where this new feature helps: If extensions are marked as “trusted” you do…

Read More
Daniel Westermann

Using PostgreSQL’s adminpack extension to write files

By | Database Administration & Monitoring | No Comments

In PostgreSQL you have several ways of working with files and you can find quite some examples here on our blog, e.g. Modifying pg_hba.conf from inside PostgreSQL, Can I do it with PostgreSQL? – 4 – External tables or Working with files on the filesystem in PostgreSQL. There is also copy which allows you to load or unload tables and there is the adminpack extension which is the topic of this post.

Read More
Burgert Daniel

Increase your PostgreSQL databases security by checking a few settings Part 2

By | Database Administration & Monitoring, Postgres, Security | No Comments

Continuing from my first blog we will check some more access and authentication configurations. Focusing on removing unnecessary database privileges. After that we will configure the backend parameters correctly to have more robust PostgreSQL server/client sessions. And at last SSL encryption for these sessions will be configured.

Read More
Julia Gugel

Patroni 2.0: New features – Patroni on pure Raft

By | Database Administration & Monitoring | No Comments

Last week the new Patroni 2.0 release was published which brings many new features. But one makes me absolutely curious. At the moment only as BETA, but I had to test it. Patroni on pure Raft. It’s possible to run Patroni without 3rd party dependencies. So no Etcd, Consul or Zookeeper is needed anymore. Great improvement! In this blog we will have a look at the setup and try an failover as well.

Read More
Furkan Suv

Starting with PostgreSQL

By | Database management, Postgres | No Comments

In this Post you will learn how I met PostgreSQL and started to learn. If you are planning PostgreSQL as your database but don’t know where to start, this blog may help you. My background I have used MySQL database like an external hard drive, just to save and store the data from an application. Several times I installed on CentOS/Ubuntu from the repository. Mostly I used preinstalled MySQL databases from webhosting providers. On the…

Read More