OmniDB is an open source web tool designed specifically for managing relational databases with focus on simplicity and user interaction, but at the same time be fast, powerful and light on memory. OmniDB, at the moment, supports several different relational database systems such as PostgreSQL. The latest release of OmniDB, version 2.3.0, has introduced ‘Debugger […]
pgxc_ctl: Teaching Postgres-XL in New York City
/0 Comments/in 2ndQuadrant, Tom's PlanetPostgreSQL /by Tom KincaidAt the 2ndQuadrant PostgreSQL conference in New York City this year, I had the pleasure of delivering a training on Postgres-XL together with Andrew Dunstan. We capped the attendees at 8 because we wanted to have a lot of lab time with the students and spend time helping them get set up with Postgres-XL. The class […]
PG Phriday: Getting RAD with Docker [Part 3]
/0 Comments/in Shaun's PlanetPostgreSQL /by Shaun ThomasBuilding an Immortal Cluster By now we’ve learned about basic Postgres Docker usage and rudimentary clustering. For the uninitiated, constructing a Postgres cluster can be a daunting task, and we’ve greatly simplified the process. So why don’t we take the next logical step and use Docker to deploy a cluster that is effectively immortal as […]
PG Phriday: Getting RAD with Docker [Part 2]
/4 Comments/in Shaun's PlanetPostgreSQL /by Shaun ThomasIn our last article, we explored how to run Postgres in some very basic Docker scenarios. Based on our experiments back then, we can obtain images, create containers, and mount to various types of storage. Boring! It’s not just boring, it’s mundane. It doesn’t do anything. Sure we can run Postgres in a container, but […]
Here’s How You Can Run OmniDB On Postgres10 [VIDEO]
/0 Comments/in Liaqat's PlanetPostgreSQL, OmniDB, PostgreSQL /by Liaqat AndrabiOmniDB is an open source web tool designed specifically for managing relational databases with focus on simplicity and user interaction, but at the same time be fast, powerful and light on memory. OmniDB, at the moment, supports several different relational database systems such as PostgreSQL. The latest release of OmniDB, version 2.3.0, has introduced ‘Debugger […]
How long does it take to change your mind?
/4 Comments/in 2ndQuadrant, Simon's PlanetPostgreSQL /by Simon RiggsYou’re clever, which means you’re mostly right about things. But everybody is wrong sometime, so how long does it take for you to change your mind? People don’t often change their minds quickly. A snap answer is always whatever you were thinking currently. If it was a No, you say No. If it was a […]
OmniDB – Now with PL/pgSQL debugger!
/0 Comments/in OmniDB, Rafael's PlanetPostgreSQL /by Rafael CastroOmniDB’s 2.3.0 release, which is coming out on November 2nd, comes with a much requested feature: a debugger for PL/pgSQL functions. This post will walk you through the steps to start debugging your functions inside OmniDB. 1. Requirements The debugger takes advantage of hooks, an extensibility in PostgreSQL’s source code that allows us to perform […]
Oracle High Availability concepts in PostgreSQL
/13 Comments/in 2ndQuadrant, Barman, PostgreSQL, Simon's PlanetPostgreSQL /by Simon RiggsSometimes people ask about certain Oracle High Availability features and whether they exist in PostgreSQL. In most cases, very similar features exist. The reason for the similarity is that PostgreSQL and Oracle have very similar architectures and so the mechanisms to protect data have also developed along the same lines. For example, Oracle Data Guard […]
PG Phriday: Getting RAD with Docker [Part 1]
/6 Comments/in Shaun's PlanetPostgreSQL /by Shaun ThomasFans of Rapid Application Development (RAD!) are probably already familiar with Docker, but what does that have to do with Postgres? Database-driven applications are a dime a dozen these days, and a good RAD environment is something of a Holy Grail to coders and QA departments alike. Docker lets us spin up a Postgres instance […]
pglogical with OmniDB
/2 Comments/in OmniDB, pglogical, William's PlanetPostgreSQL /by William Ivanski1. Introduction pglogical is an extension that provides an advanced logical replication system that serves as a highly efficient method of replicating data as an alternative to physical replication. Here we will show how to build a test environment to play with PostgreSQL and pglogical, and how to configure it using the OmniDB 2.2 web […]
Postgres-XL with OmniDB
/1 Comment/in OmniDB, William's PlanetPostgreSQL /by William Ivanski1. Introduction Postgres-XL (or just XL, for short) is an open source project from 2ndQuadrant. It is a massively parallel database built on top of PostgreSQL, and it is designed to be horizontally scalable and flexible enough to handle various workloads. Here we will show how to build a test environment to play with XL […]