Tag: PostgreSQL

Summary In this blog I will explain pg_rewind use case to solve split brain after a database failover happens. Split Brain Syndrome Split Brain is often used to describe the scenario when two or more nodes in a cluster, lose…

PostgreSQL, is built on the backbone of its supportive community. Pythian’s team of database experts support and want to continue to grow our contribution to the PostgreSQL community. One of the ways our database experts are contributing is through speaking…

Security is the measure role of the database in terms of data and user level. One of the most important security concerns is a user’s  password, which should be both confidential and complex. In this post, I’ll explain and implement…

An important part of PostgreSQL monitoring is looking at how many transaction logs or WAL (Write Ahead Logs) files that are produced. WALs are produced as a part of the MVCC (MultiVersion Concurrency Control) that PostgreSQL uses. WAL ensures that…

Google just recently launched the public preview of their new customized cloud version of PostgreSQL called AlloyDB. This Google Cloud Platform (GCP) managed database service is not the same as their Cloud SQL PostgreSQL service that still exists and is…

Whether you’re using a PostgreSQL, MySQL or SQL Server relational database, a migration to Google Cloud SQL can take it up a notch—automating management tasks, ensuring business continuity and staying up-to-date with security and compliance requirements. And, with a solution…

When working with clients on database migration, there are a range of options we help them assess and evaluate. These include: Bare Metal Solution (BMS) PostgreSQL On Cloud SQL On GCE (Google Compute Engine) Cloud Spanner Some organizations choose BMS…

When I first heard of Postgres partial indexes, I knew immediately that this would have solved a problem I had in MySQL about a decade ago. That problem didn’t go unsolved, but it certainly wasn’t as easy as I’ll demonstrate…

There were some security patches released this month for Postgres, to put further restrictions on pathways that malicious users could use to leverage the search_path to insert malicious code. What is the search path? What is search_path? Postgres has a…

Covering indexes in Postgres came up in our weekly tech call because of a query optimization review one of the teams has in progress. It seemed like some covering indexes weren’t working. I’ve been reading a book called Curious Moon,…