Venkata Nagothi

This blog provides an overview of the services offered by the cloud provider DigitalOcean for deployment and managing a PostgreSQL database.

Logical Replication or pglogical is a method of replicating specific data objects (tables) and their changes to the replica in real-time which is similar to streaming replication. The term logical is in contrast to physical replication, which uses exact block addresses and byte-by-byte replication. This blog provides tips on how to optimize logical replication system.

Business continuity for databases means databases must be continuously operational even during the disasters. It is imperative to ensure that production databases are available for the applications all the time even during the disasters, otherwise, could end-up being an expensive deal.

In a busy database environment with larger size databases, the need for real-time data replication is a common occurrence. Applications often need the production data to be replicated in real-time to remote sites for analytics and other critical business operations needs. This blog provides an overview of several options you can use to replicate your PostgreSQL data to a remote site.

This blog provides an overview of the JSON capabilities within PostgreSQL which were released in version 9.2.

Barman is a backup and disaster recovery solution for PostgreSQL databases that allow you to achieve high business continuity requirements.

PostgreSQL I/O is quite reliable, stable and performant on pretty much any hardware, including cloud.  In this blog, we detail steps you can take to tune the input and outputs of your PostgreSQL database.

This blog provides an overview of popular authentication systems based on LDAP, Kerberos and RADIUS, and how to integrate them with your PostgreSQL database.

This blog reviews what ETL is and what tools are available to help you migrate your data to a PostgreSQL database.