Search results for postgres install source code

Can I do it with PostgreSQL? – 12 – dbca (database configuration assistant)

Short answer: No. Long answer: No. Every other possible answer: No. There is no such tool in PostgreSQL. In Oracle you can use the database configuration assistant to create your Oracle database. But this is not a must,(…)

Vertically scale your PostgreSQL infrastructure with pgpool – 3 – Adding another standby

In the first and second post in this series we did the basic pgpool setup including the watchdog configuration and then did a simple setup for automatically failover from a PostgreSQL master instance in case it(…)

Temporal tables with PostgreSQL

By Mouhamadou Diaw In this blog we are going to talk about a nice extension in PostgreSQL: temporal_tables. This extension provides support for temporal tables. What is a temporal table? Just a table that tracks the period(…)

From PostgreSQL 9.1.8 to PostgreSQL 9.5.5 including a standby database with minimal downtime

As you might know PostgreSQL 9.1 is out of support since last September. But, no surprise, there are still plenty of PostgreSQL 9.1 instances out there which need to be upgraded to a supported release. At one(…)

From MySQL (Oracle) to Postgres using the EDB Migration Toolkit

Why should you migrate? If your current MySQL database does not offer some needed functionnalities according to your business as: – more security – more high availibilty options (hot standby) – Strong Data Warehouse capabilities(…)

Running PostgreSQL on ZFS on Linux

ZFS for Solaris is around for several years now (since 2015). But there is also a project called OpenZFS which makes ZFS available on other operating systems. For Linux the announcement(…)

Auditing in PostgreSQL

Today, especially in the Pharma and Banking sectors, sooner or later you will be faced with the requirement of auditing. Detailed requirements will vary but usually at least tracking logons to the database is a must. Some companies need more(…)

Getting started with Ansible – Installing OS packages, creating groups and users

It has been quite a while since the first post in this series: "Getting started with Ansible - Preparations". If you recap from the initial post Ansible was running on the control host and this simple Ansible(…)

Install PL/JAVA in PostgreSQL 9.5.1

Some time ago I blogged about how to install PL/JAVA in Postgres Plus Advanced Server 9.5. This resulted in an interesting comment from the maintainer of PL/Java. After(…)

Migration d’Oracle vers PostgreSQL avec ora2pg

Le propos des trois posts PostgreSQL qui vont suivre, est de présenter: la mise en place d’un outil d’aide à la migration d’une base Oracle, au sens du schéma, vers une base PostgreSQL L’utilisation de cet outil, nommé ora2pg(…)