The Current State of Open Source Backup Management for PostgreSQL
There are many ways to address taking backups of a PostgreSQL cluster. There are several articles and blogs which present the various technologies by which we can save our precious data in PostgreSQL. There are...
Migrating from DB2 to PostgreSQL – What You Should Know
Whether migrating a database or an application from DB2 to PostgreSQL, there are few things to know about the differences between the two database systems. PostgreSQL is world’s most widely used advanced open-source database. PostgreSQL...
How to Cluster Odoo 12 with PostgreSQL Streaming Replication for High Availability
Odoo (formerly known as OpenERP) is a suite of open-source business apps. It comes in two versions - community and enterprise. Some of the most popular apps (and free!) integrated within this platform are Discuss,...
Basic Administration Comparison Between Oracle, MSSQL, MySQL, PostgreSQL
The introduction of DevOps in organizations has changed the development process and also introduced some new challenges. In addition, developers and DevOps teams, along with their own chosen programming languages, also have their favorite database...
An Overview of the Index Changes in PostgreSQL 11
The right application of indexes can make queries blazing fast. Indexes use pointers to access data pages in a speedy fashion. Major changes happened on Indexes in PostgreSQL 11, lots of much awaited patches have...
Automate Deployment of Your MySQL or Postgres Cluster From Backup
ClusterControl 1.7.1 introduces a new feature called Create Cluster from Backup, which allows you to deploy a new MySQL or Postgres-based cluster and restore data on it from a backup. This blog post shows how...
PostgreSQL High Availability with Master-Slave & Master-Master Architectures
Below is an excerpt from our whitepaper “PostgreSQL Management and Automation with ClusterControl” which can be downloaded for free. Revision Note: Keep in mind that the terms used in this blog Master-Slave are synonymous of Master-Standby...
Top GUI Tools for PostgreSQL
Managing databases from the command line does come with a learning curve to get the most out of it. The command line can sometimes be arduous and the display may not be optimal for what...
How to Manage Your PostgreSQL Databases From the ClusterControl CLI
Did you know that apart from the ClusterControl web UI, you can also use a command line interface to manage your PostgreSQL instances? ClusterControl supports PostgreSQL streaming replication (both asynchronous and synchronous replication) as well...
Webinar Replay: How to Automate & Manage PostgreSQL with ClusterControl
Thanks to everyone who joined our first webinar of 2019! Our colleague Sebastian Insausti walked us through all the ins and outs of how to automate and manage PostgreSQL with ClusterControl! You can now watch...
An Overview of JSON Capabilities Within PostgreSQL
What is JSON? JSON stands for “JavaScript Object Notation” which is a type of data format popularly used by web applications. This means, the data would be transmitted between web applications and servers in such...
One Security System for Application, Connection Pooling and PostgreSQL – The Case for LDAP
Traditionally, the typical application consists of the following components: In this simple case, a basic setup would suffice: the application uses a simple local authentication mechanism for its users the application uses a simple connection...