PostgreSQL Connection Pooling: Part 3 – Pgpool-II

Posted: March 23, 2020

In our previous posts in this series, we discussed the case for connection pooling and introduced PgBouncer. In this post, we will discuss its most popular alternative - Pgpool-II. Pgpool-II is the swiss army knife of PostgreSQL middleware. It supports high-availability, provides automated load...

Read Article

PostgreSQL Connection Pooling: Part 2 – PgBouncer

Posted: December 19, 2019

When it comes to connection pooling in the PostgreSQL world, PgBouncer is probably the most popular option. It's a very simple utility that does exactly one thing - it sits between the database and the clients and speaks the PostgreSQL protocol, emulating a PostgreSQL server. A client connects to...

Read Article

Making it Easier to Manage a Production PostgreSQL Database

Posted: November 12, 2019

The past several years have seen increasing adoption for PostgreSQL. PostgreSQL is an amazing relational database. Feature-wise, it is up there with the best, if not the best. There are many things I love about it - PL/ PG SQL, smart defaults, replication (that actually works out of the box), and...

Read Article

What’s the Best PostgreSQL High Availability Framework? PAF vs. repmgr vs. Patroni Infographic

Posted: October 31, 2019

Wondering which high availability framework to use for your PostgreSQL deployments? We compared the top 3 frameworks, PostgreSQL Automatic Failover (PAF) vs. Replication Manager (repmgr) vs. Patroni, in our Managing High Availability in PostgreSQL series. In these blogs, we dove deep into how...

Read Article

PostgreSQL Connection Pooling: Part 1 – Pros & Cons

Posted: October 17, 2019

A long time ago, in a galaxy far far away, ‘threads’ were a programming novelty rarely used and seldom trusted. In that environment, the first PostgreSQL developers decided forking a process for each connection to the database is the safest choice. It would be a shame if your database crashed,...

Read Article

PostgreSQL Trends: Most Popular Cloud Providers, Languages, VACUUM, Query Management Strategies & Deployment Types in Enterprise

Posted: October 7, 2019

PostgreSQL popularity is skyrocketing in the enterprise space. As this open source database continues to pull new users from expensive commercial database management systems like Oracle, DB2 and SQL Server, organizations are adopting new approaches and evolving their own to maintain the exceptional...

Read Article

Which Is the Best PostgreSQL GUI? 2019 Comparison

Posted: September 16, 2019

PostgreSQL graphical user interface (GUI) tools help these open source database users to manage, manipulate, and visualize their data. In this post, we discuss the top 5 GUI tools for administering your PostgreSQL deployments. PostgreSQL is the fourth most popular database management system in the...

Read Article

Managing High Availability in PostgreSQL – Part III: Patroni

Posted: August 22, 2019

In our previous blog posts, we discussed the capabilities and functioning of PostgreSQL Automatic Failover (PAF) by Cluster Labs and Replication Manager (repmgr) by 2ndQuadrant. In the final post of this series, we will review the last solution, Patroni by Zalando, and compare all three at the end...

Read Article

Fully Managed PostgreSQL Hosting on AWS and Azure Launches in Time For Legacy Migrations

Posted: July 17, 2019

PALO ALTO, Calif., July 17, 2019 - ScaleGrid, a leader in the Database-as-a-Service (DBaaS) space, has just announced support for PostgreSQL hosting in the cloud. The fully managed platform allows organizations to automate their time-consuming PostgreSQL operations, focus on database development,...

Read Article

2019 PostgreSQL Trends Report: Private vs. Public Cloud, Migrations, Database Combinations & Top Reasons Used

Posted: April 2, 2019

PostgreSQL is an open source relational database system that has soared in popularity over the past 30 years from its active, loyal, and growing community. For the 2nd year in a row, PostgreSQL has kept the title of #1 fastest growing database in the world according to the DBMS of the Year report...

Read Article

Search Results for: PostgreSQL

PostgreSQL Connection Pooling: Part 3 – Pgpool-II

PostgreSQL Connection Pooling: Part 2 – PgBouncer

Making it Easier to Manage a Production PostgreSQL Database

What’s the Best PostgreSQL High Availability Framework? PAF vs. repmgr vs. Patroni Infographic

PostgreSQL Connection Pooling: Part 1 – Pros & Cons

Which Is the Best PostgreSQL GUI? 2019 Comparison

Managing High Availability in PostgreSQL – Part III: Patroni

Fully Managed PostgreSQL Hosting on AWS and Azure Launches in Time For Legacy Migrations

2019 PostgreSQL Trends Report: Private vs. Public Cloud, Migrations, Database Combinations & Top Reasons Used

Search:

About us:

You may also be interested in

MongoDB

Redis™

MySQL

PostgreSQL

Pricing

About Us

Resources

DPA