Infrastructure at your Service

PostgreSQL Archives - Blog dbi services

Mouhamadou Diaw

History of Upgrading 9 Tb PostgreSQL database

By | Database Administration & Monitoring | No Comments

In this blog I am going share a history of PostgreSQL migration and upgrade from 9.2 to 9.6. Let me first explain the context We have a PostgreSQL environment with following characteristics. Note that real database name, server name are changed for security reason Host: CentOS release 6.4 PostgreSQL version: 9.2 Database size : 9Tb postgres=# select version(); version ————————————————————————————————— ———— PostgreSQL 9.2.4 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2- 52),…

 
Read More
Daniel Westermann

Replicating from Oracle to PostgreSQL with EDB Replication Server – 1 – A simple replication setup

By | Database Administration & Monitoring | No Comments

When you want to offload reporting stuff from Oracle to PostgreSQL there are several solutions you can go for. There most widely known probably are Oracle GoldenGate and SharePlex. EnterpriseDB has its own solution for this which is called EDB Replication Server. As soon as you have one subscription from EnterpriseDB this tool is included and can be used to offload from Oracle to PostgreSQL. Lets do a simple replication setup and see how it…

 
Read More
Daniel Westermann

PostgreSQL on a Pure Storage All Flash Array – Populating PostgreSQL

By | Database Administration & Monitoring | No Comments

Just be clear this is not a performance test as we had to connect the Pure Storage box through 1GB/s interfaces. Basically it is more about how you can interact with the storage system (command line & web interface) and to get a feeling on what is possible. In the last post we explained on how we did the setup for connecting a PostgreSQL server to the Pure Storage array. In this post we’ll actually…

 
Read More
Daniel Westermann

Testing new PostgreSQL features before alpha/beta/rc releases

By | Database Administration & Monitoring | No Comments

A long time ago I blogged on how you can use the PostgreSQL development snapshots to test new PostgreSQL features before alpha/beta/rc releases are officially released. Another way to do this is to use git to get the latest sources and build PostgreSQL from there. Everything which was committed will be available to test. Btw: A great way to stay up to date is to subscribe to the mailing list just referenced. You’ll get a…

 
Read More
Daniel Westermann

PostgreSQL on a Pure Storage All Flash Array – Preparations

By | Database Administration & Monitoring | No Comments

Yesterday we got a Pure Storage All Flash Array for testing. As the name implies this is all about Flash storage. What makes Pure Storage different from other vendors is that you don’t buy just a storage box and then pay the usual maintenance costs but you pay for a storage subscription which should keep your storage up to date all the time. The promise is that all the components of the array get replaced…

 
Read More
Daniel Westermann

Save the date: Swiss PGDay 2017

By | Database Administration & Monitoring | No Comments

The 30th of June is not too far away and if you want to learn more about the “World’s most advanced open source database” you should register soon. The sessions are not yet officially announced but you can expect that to happen next week. What we can say already is that we will be there and that you can expect these sessions from dbi: How to migrate data from MongoDB to Postgres with ToroDB Elking…

 
Read More
Daniel Westermann

Does the wal segment size matter in PostgreSQL?

By | Database Administration & Monitoring | 2 Comments

In PostgreSQL you configure the size of the wal (write ahead log) segments when you compile from source. If you use an installer or if you use the packages provided by your OS distribution the size of the wal segments is usually 16MB. Although 16MB seems very low you don’t need to worry about that in most of the cases, it just works fine. However there are cases where you might want to adjust this,…

 
Read More
Daniel Westermann

In-core logical replication will hit PostgreSQL 10

By | Database Administration & Monitoring | No Comments

Finally in PostgreSQL 10 (expected to be released this September) a long awaited feature will probably appear: In-core logical replication. PostgreSQL supports physical replication since version 9.0 and now the next step happened with the implementation of logical replication. This will be a major help in upgrading PostgreSQL instances from one version to another with no (or almost no) downtime. In addition this can be used to consolidate data from various instances into one instance…

 
Read More