Starting with Oracle Database 12.2.0.1 the orapwd utility β used to create Password Files for remote authentication β enforces complexity rules for the provided password.…
View More orapwd enforces password complexity rules in 12.2.0.1
Month: June 2023
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
Materialized View Strategies Using PostgreSQL
Queries returning aggregate, summary, and computed data are frequently used in application development. Sometimes these queries are not fast enough. Caching query results using Memcached…
View More Materialized View Strategies Using PostgreSQL