Infrastructure at your Service

All Posts By

Mouhamadou Diaw

Mouhamadou Diaw

PostgreSQL : barman rsync method vs streaming method

By | Database Administration & Monitoring, Postgres | 4 Comments

Barman is a tool to perform backup and recovery for PostgreSQL databases. It can do backup using two methods: -rsync/ssh -streaming In this blog I am going to explain how to use these two methods to backup a PostgreSQL database. Generally it is a good practice to dedicate a server for barman instead of installing it on the database server. My environment is described below postgreSQL server: dbi-pg-essentials 192.168.22.101 Centos 7 barman server: pgservertools 192.168.22.104…

Read More
Mouhamadou Diaw

PostgreSQL: When wal_level to logical

By | Database Administration & Monitoring, Postgres | No Comments

wal_level determines the quantity of information written to the WAL. With PostgreSQL 11 the parameter wal_level can have 3 values: -minimal : only information needed to recover from a crash or an immediate shutdown -replica : enough data to support WAL archiving and replication -logical : enough information to support logical decoding. If we want to use logical decoding, wal_level should be set to logical. Logical decoding is the process of extracting all persistent changes…

Read More
Mouhamadou Diaw

EDB Failover Manager 3.3 With Virtual Ip Address

By | Database Administration & Monitoring, Postgres | One Comment

In a previous blog , I talked about installing and configuring Edb Failover Manager with PostgreSQL. The configuration of a Virtual Ip Address was not discussed in this previous article.In this blog I am going to show how we can implement a virtual IP with EFM. We suppose that -The standby is already built -EFM is configured and running (see here for the configuration) Below our configuration ( Iam using PostgreSQL 11.1 with Centos 7)…

Read More
Mouhamadou Diaw

PAM Authentication With PostgreSQL

By | Database Administration & Monitoring, Postgres | 2 Comments

PostgreSQl supports many authentication methods. The PAM authentication method operates similarly to password except that it uses PAM (Pluggable Authentication Modules) as the authentication mechanism. The user must exist in the database before PAM can be used for authentication. In this blog I will configure PAM authentication for a PostgreSQL cluster 11 running on a centos 7. postgres=# select version(); version ——————————————————————————– ————————- PostgreSQL 11.1 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (R ed…

Read More
Mouhamadou Diaw

PostgreSQL : Get my database server name

By | Database Administration & Monitoring | No Comments

I was looking for a build-in function to get the hostname of the server hosting my PostgreSQL cluster. But seems that there is no build-in function. Looking in the extensions, I find the extension hostname which can allow to get the database server host name. In this this blog I am explaining how to install and how to use it. The installation is very easy. The first step is to download it here . After…

Read More
Mouhamadou Diaw

PostgreSQL 12 : New option –socketdir for pg_upgrade

By | Database Administration & Monitoring, Postgres | No Comments

PostgreSQL 12 is under development but tests can be done. Steps to install this version can be found in this dbi blog . Many thanks to Daniel. While reading the documentation I found that there is a new parameter for pg_upgrade. This new parameter is –socketdir. Why this parameter? In fact the path name of a UNIX socket is allowed to be maximally 108 chars long. Before PostgreSQL 12, the default directory for the sockets…

Read More
Mouhamadou Diaw

Oracle OpenWorld 2018: Day 3

By | Database Administration & Monitoring | No Comments

Today my first session was about GDPR Data Security in the GDPR Era. It was presented by Joao Nunes, IT Senior Manager, NOS Tiago Rocha, Database Administrator, “Nos Comunicaões, Sa.” Eric Lybeck, Director, PwC The speakers started by presenting what is GDPR which is a new law protecting data for European citizens. After they explain the changes for companies about this new law. They talk about the GDPR articles related to Oracle Database Security. And…

Read More
Mouhamadou Diaw

Oracle OpenWorld 2018: Day 2

By | Database Administration & Monitoring | No Comments

Today is my second day of Oracle OpenWorld 2018. I can now go to the Moscone Center without GPS (cool) and then I decided to follow a MySQL session (my boss will be happy). Yes my first session was Using the MySQL Binary Log as a Change Stream by Luis Soares, Software Development Director, Oracle The speaker explains what are the binary logs. How to initialize the binary logs and how to manage them How…

Read More
Mouhamadou Diaw

Oracle OpenWorld 2018: Day 1

By | Database Administration & Monitoring | No Comments

The first session I assisted today was Oracle Active Data Guard: Best Practices and New Features Deep Dive. This session was done by Nitin Karkhanis Director of Software Development managing the Data Guard Broker development team and Mahesh Girkar Senior Director of Software Development in Oracle’s Database Division. His team is responsible for developing High Availability features for Data Guard and Active Data Guard.. It was really a very interesting session. It was divided in…

Read More
Mouhamadou Diaw

Oracle OpenWorld 2018: Day 0

By | Database Administration & Monitoring | No Comments

Today was the day 0 for the oracle Openworld 2018. The event is officially not started but there were many nice entertainments to discover and enjoy San Francisco. The one Gregory Steulet (CFO of dbi services) and myself participated was the bike ride organized by Bryn Llewellyn who is the PL/SQL Product Manager. There were also Mike Dietrich (Master Product Manager) ,Franck Pachot (Oracle Master 12c and ACE Director) and many other people After renting…

Read More