OmniDB Archives - Page 2 of 2 - 2ndQuadrant

pglogical with OmniDB

October 19, 2017/2 Comments/in OmniDB, pglogical, William's PlanetPostgreSQL /by William Ivanski

1. 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

October 17, 2017/0 Comments/in OmniDB, William's PlanetPostgreSQL /by William Ivanski

1. 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 […]

Postgres-BDR with OmniDB

September 28, 2017/0 Comments/in OmniDB, William's PlanetPostgreSQL /by William Ivanski

1. Introduction Postgres-BDR (or just BDR, for short) is an open source project from 2ndQuadrant that provides multi-master features for PostgreSQL. Here we will show how to build a test environment to play with BDR and how to configure it using the OmniDB 2.1 web interface. 2. Building test environment Let’s build a 2-node test […]

PostgreSQL 10 Logical Replication with OmniDB

September 19, 2017/0 Comments/in OmniDB, William's PlanetPostgreSQL /by William Ivanski

1. Introduction Logical replication uses a publish/subscribe model and so we create publications on the upstream (or publisher) and subscriptions on downstream (or subscriber). For more details about it, please refer to this blog post from my colleague Petr Jelinek, and also to the PostgreSQL documentation. Here we will show how to build a test […]

OmniDB: Average execution time of PostgreSQL webmethods

August 29, 2017/0 Comments/in OmniDB, William's PlanetPostgreSQL /by William Ivanski

1. Introduction Being a web application, OmniDB is composed of many webmethods. A webmethod is a special kind of function hosted on the server side (the web server), called from the client side (the web browser), when the user performs some action on OmniDB web interface. For instance, OmniDB has several webmethods that know how to […]

pglogical with OmniDB

Postgres-XL with OmniDB

Postgres-BDR with OmniDB

PostgreSQL 10 Logical Replication with OmniDB

OmniDB: Average execution time of PostgreSQL webmethods

Support & Services

Products

Postgres Learning Center

About Us