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...
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...
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...
Deploying and Managing PostgreSQL 11: New in ClusterControl 1.7.1
A few days ago was the release of a new version of ClusterControl, the 1.7.1, where we can see several new features, one of the main ones being the support for PostgreSQL 11. To install...
An Overview of Just-in-Time Compilation (JIT) for PostgreSQL
Historically PostgreSQL has provided compilation features in the form of ahead-of-time compilation for PL/pgSQL functions and version 10 introduced expression compilation. None of those generate machine code though. JIT for SQL was discussed many years...
PostgreSQL Replication for Disaster Recovery
With Disaster Recovery, we aim to set up systems to handle anything that could go wrong with our database. What happens if the database crashes? What if a developer accidently truncates a table? What if...
PostgreSQL on the Rise: 2018 Postgres Findings & 2019 Trends
A strong community coupled with an increasingly stable and feature-rich platform are making PostgreSQL a strong contender for replacing the “big boys” of enterprise data. We here at Severalnines have also seen this trend and...
Using PostgreSQL Logical Replication to Maintain an Always Up-to-Date Read/Write TEST Server
In this blog entry we’ll talk about logical replication in PostgreSQL: its use cases, general information on the status of this technology, and a special use case in particular on how to setup a subscriber...