Infrastructure at your Service

Category

Postgres

Mouhamadou Diaw

PostgreSQL 12: New option –exclude-database for pg_dumpall

By | Database Administration & Monitoring, Postgres | No Comments

Up to PostgreSQL 11 pg_dump all was used to dump all PostgreSQL databases of a cluster into one script file. The script file then contains SQL commands that can be used as input to psql to restore the databases. It does this by calling pg_dump for each database in the cluster. PostgreSQL 12 is under development but we can test new features which will be implemented. Now with PostgreSQL 12 there is a new option…

Read More
Mouhamadou Diaw

PostgreSQL : barman rsync method vs streaming method

By | Database Administration & Monitoring, Postgres | 2 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 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
Joël Cattin

From Oracle to Postgres with the EDB Postgres Migration Portal

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

EnterpriseDB is a valuable actor in PostgreSQL’s world. In addition to provide support, they also deliver very useful tools to manage easily your Postgres environments. Among these we can mention EDB Enterprise Manager, EDB Backup & Recovery Tool, EDB Failover Manager, aso… With this post I will present one of the last in the family, EDB Postgres Migration Portal, a helpful tool to migrate from Oracle to Postgres. To acces to the Portal, use your…

Read More
Oracle Team

Drilling down the pgSentinel Active Session History

By | Database Administration & Monitoring, Postgres | No Comments

By Franck Pachot . In pgSentinel: the sampling approach for PostgreSQL I mentioned that one of the advantages of the ASH approach is the ability to drill down from an overview of the database activity, down to the details where we can do some tuning. The idea is to always focus on the components which are relevant to our tuning goal: Filter/Group by the relevant dimension to focus on what you want to tune (a…

Read More
Oracle Team

pgSentinel: the sampling approach for PostgreSQL

By | Database Administration & Monitoring, Postgres | 5 Comments

By Franck Pachot . Here is the first test I did with the beta of pgSentinel. This Active Session History sampling is a new approach to Postgres tuning. For people coming from Oracle, this is something that has made our life a lot easier to optimize database applications. Here is a quick example showing how it links together some information that are missing without this extension.

Read More