Infrastructure at your Service

Category

Postgres

Mouhamadou Diaw

PostgreSQL 12 : Setting Up Streaming Replication

By | Database Administration & Monitoring, Postgres | No Comments

PostgreSQL 12 was released a few month ago. When actually setting up a replication, there is no longer recovery.conf file in the PGDATA. Indeed all parameters of the recovery.conf should be now in the postgresql.conf file. And in the cluster data directory of the standby server, therre should be a file named standby.signal to trigger the standby mode. In this blog I am just building a streaming replication between 2 servers to show these changes….

Read More
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 | 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