Tags » PostgreSQL

Updated pbuilder4cpp, 1.1606 released

pbuilder4cpp 1.1606 has been released. This version is a port to Ubuntu 16.04.

Enjoy it!


Trees (1) : the Adjacency List Model

We begin with a description of recursive CTEs, a SQL pattern  that will be used afterwards.

What is a CTE ?
A CTE (Common table expression) is a view local to a query : a substitute for a view when the general use of a view is not required. 2,174 more words


Meet the MicroOLAP Database Designer for PostgreSQL 1.11.3

Database Designer for PostgreSQL is an comprehensive CASE tool which works natively under Windows OS family and Linux under Wine/WineHQ allowing you to

  • build a clear and effective database structure visually,
  • 234 more words

Postgres 9.4 to 9.5 database migration x Fedora 24

Fedora changed major versions of the postgresql database package, meaning that all user databases have to migrated from the 9.4.x series that used to be the default, to the 9.5.x series that is the current upstream stable package. 165 more words

Replication(Master/Slave) of PostgreSQL database

Before you proceed this handy procedure, be sure you take backup of the databases.

 pg_dumpall > dump.sql


  1. Two Ubuntu(14.04) instances:
  2. PostgreSQL 9.4.x…
  3. 404 more words

New Requirement! - Linux Specialist / Dev Ops - RHEL, Windows – SC cleared- Hampshire, Contract

Skills: Linux Specialist / Dev Ops – RHEL 5.1x and 6.5 (install and troubleshooting, Windows – SC cleared. You must be Security Cleared to SC level, please do not send in your CV if you are not. 191 more words


Who Runs Your Data?

A database, a place where data is stored, is crucial for a successful application.  The big players on the league are IBM’S DB2, Oracle’s Database 12c… 109 more words