Managing traffic to the database can get harder and harder as it increases in amount and the database is actually distributed across multiple servers. PostgreSQL…
View More PostgreSQL Replication Setup using HAProxy
Tag: postgresql
How to use pgBouncer with PostgreSQL
In the database world, there are many common concepts like High Availability, Failover, and Connection pooling. All of them are useful things to implement on any…
View More How to use pgBouncer with PostgreSQL
PostgreSQL Connection Pooling with PgBouncer
Connection pooling is a simple but effective way to improve the performance of your apps and decrease the load on your PostgreSQL servers. Read on…
View More PostgreSQL Connection Pooling with PgBouncer
Migrating partitioned Oracle database tables to PostgreSQL
Table partitioning is a useful functionality that most organizations use to store huge data, and it is quite common for users to come across partition…
View More Migrating partitioned Oracle database tables to PostgreSQL
PostgreSQL Architecture
PostgreSQL is probably the most advanced database in the open source relational database market. It was first released in 1989, and since then, there have been…
View More PostgreSQL Architecture
Amazon AWS upgrades to Postgres with Bucardo
Amazon Relational Database Service (RDS), allows for quick setup and use of a database system. Despite minimizing many database administration tasks, some issues still exist, one…
View More Amazon AWS upgrades to Postgres with Bucardo
Upgrade PostgreSQL RDS from version 9.x to 12.x using Bucardo
We are using Aurora PostgreSQL RDS clusters as our Database for our Applications. We were using a 9.x version of Aurora PostgreSQL RDS clusters for…
View More Upgrade PostgreSQL RDS from version 9.x to 12.x using Bucardo
PostgreSQL Connection Pooling and Load Balancing with PgPool-II Cluster
In this post, I will walk you through on how to perform load balancing and connection pooling with PgPool-II, what are the benefits and motivation…
View More PostgreSQL Connection Pooling and Load Balancing with PgPool-II Cluster
Upgrading the PostgreSQL DB engine for Amazon RDS from 11.9 to 12.4
In this article, I will share how upgraded the PostgreSQL from 11.9 to 12.4 in AWS RDS. Make sure that you thoroughly test after the…
View More Upgrading the PostgreSQL DB engine for Amazon RDS from 11.9 to 12.4
Understanding database Indexes in PostgreSQL
There are three types of developers: those who know that indexes speed up database queries, those who know that indexes speed up database queries and…
View More Understanding database Indexes in PostgreSQL