Search results for postgres install source code

The size of Oracle Home: from 9GB to 600MB – What about PostgreSQL?

A recent blog post from Franck and a tweet around that topic is the inspiration for this blog post, thanks Jan for requesting :). In short it is about how small(…)

pgSentinel: the sampling approach for PostgreSQL

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(…)

Lighty for PostgreSQL

By Franck Pachot . If you follow this blog, you should know how I like Orachrome Lighty for Oracle, for its efficiency to monitor database performance statistics. Today Orachrome released the beta version of Lighty for Postgres:(…)

How to compile PostgreSQL 11 with support for JIT compilation on RHEL/CentOS 7

As you might already know PostgreSQL 11 will bring support for just-in-time compilation. When you want to compile PostgreSQL 11 with jit support on RedHat/CentOS 7 this requires a little hack (more on the reason below). In(…)

How we build our customized PostgreSQL Docker image

Docker becomes more and more popular these days and a lot of companies start to really use it. At one project we decided to build our own customized Docker image instead of using the official PostgreSQL one.

Replicating specific tables in PostgreSQL 10 Beta with mimeo

By Mouhamadou Diaw In this blog I am going to test the extension mimeo with PostgreSQL 10 beta. Mimeo is a replication extension for copying specific tables in one of several specialized ways from any number of source databases to(…)

PostgreSQL on Cygwin

By Franck Pachot . I run my laptop with Windows 10 for office programs, and VirtualBox machines with Linux for the big stuff (Oracle databases). I have also Cygwin installed on Windows for GNU programs. I wanted to quickly install(…)

History of Upgrading 9 Tb PostgreSQL database

Mouhamadou Diaw 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,(…)

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

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(…)

Migrating from oracle to postgresql with ora2pg

By Mouhamadou Diaw PostgreSQL is one of the most used Rdbms. In this blog we are going to talk about migrating from oracle to postgresql using ora2pg. A previous blog about this topic can be found(…)