All articles

8000 PostgreSQL clusters on one host?

Coming back to the last post: 8000 databases in one PostgreSQL cluster?. As we've seen this is doable but comes with a lot of pain points. Another solution for this kind of requirement would be to host(…)

Oracle DB on Azure with Multitenant Option

By Franck Pachot . If you want to run an Oracle Database in the Microsoft Azure cloud, you will install it yourself on a VM. And then, you can expect the same as when you install it in your(…)

PostgreSQL on FreeBSD, installation from source code

This is the next post in this little series about PostgreSQL on FreeBSD. You can find the previous one here: PostgreSQL on FreeBSD, getting started PostgreSQL on FreeBSD, updating & configuration(…)

PostgreSQL on FreeBSD, installation from packages

In the last two posts we installed FreeBSD, configured networking, updated the system, installed bash and had a quick look at kernel parameters. In this post we'll install PostgreSQL from packages. Of course you(…)

JENKINS create a pipeline using Blue Ocean

Hi everybody, Last time we have seen what is Pipeline concepts including scripted and declarative pipeline methods.Today we will see how to create easily a declarative pipeline using Blue ocean tool.It will allow us to generate a workflow without(…)

PostgreSQL on FreeBSD, updating & configuration

In the last post we installed FreeBSD, configured the keyboard, time zone and the first network interface, which gets it's IP address via DHCP. In this post we'll look at how we can configure the second interface,(…)

Grafana, SQL and IN() list for multi-value variable

By Franck Pachot . I’ve recently looked at Grafana. Pros: it is really nice, I mean aesthetically. If you want to build a dashboard for your boss, or put it on a large screen in the open space, that’s(…)

PostgreSQL on FreeBSD, getting started

Although we are running PostgreSQL mostly on Linux distributions, you can install an run PostgreSQL on a lot of other operating systems. On of them is FreeBSD. FreeBSD is one of those Unixes that derived from the(…)

SUMA Server Part 2

In my previous Blog I wrote how to install and configure SUSE Manager. In this Blog I will go more in the deep like repository management and PXE boot configuration. Configuring repository To syncronize(…)

JENKINS – Introduction to pipelines

Hi, We already know how to create a build on Jenkins using freestyle job, it’s a quick way to make a job, but what happened when we want to have complex tasks and workflow to trigger? Freestyle job limitation Indeed(…)