You can use the PostgreSQL pg_cron extension to schedule maintenance commands within a PostgreSQL database. For more information about the extension, see What is pg_cron? in the pg_cron documentation.…
View More Scheduling maintenance with the PostgreSQL pg_cron extensionCategory: Postgres
Postgres
PostgreSQL Replication Setup using HAProxy
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 HAProxyHow 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 PostgreSQLPostgreSQL 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 PgBouncerMigrating 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 PostgreSQLPostgreSQL 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 ArchitectureAmazon 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 BucardoUpgrade 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 BucardoPostgreSQL 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 ClusterUpgrading 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