Tag : postgres

Debugging Slow BOSH Deployed PostgreSQL

Photo by Vincent van Zalinge on Unsplash Something is just not quite right, the CLI is sluggish and your senses are tingling that something is wrong. Is it the database? Maybe. How do you know? pgBadger is a nifty tool that reads through postgres logs and generates a report showing slow queries, table locks, DML

Chris Weibel Profile Image

Posted by:
Chris Weibel

Read More ➝
Where is PostgreSQL Getting That $%&^ing Configuration Parameter From?

​ Photo by Steve Smith on Unsplash Like a squirrel looking for a lost nut, finding where a configuration parameter is being set in PostgreSQL can be a pain in the (fluffy) tail. For example, the log_min_duration_statement which is used to configure the threshold duration of a query before it is logged can be set

Chris Weibel Profile Image

Posted by:
Chris Weibel

Read More ➝
Adding pgBadger to the PostgreSQL Helm Chart

pgBadger is a helpful tool which will generate reports and diagrams about the type and pattern of sql queries over time that are submitted to PostgreSQL. The tool works by reading the PostgreSQL logs (not transaction logs) which are not typically enabled by default in the helm chart. Below are a few methods for leveraging

Chris Weibel Profile Image

Posted by:
Chris Weibel

Read More ➝
Running the CrunchyData Postgres Operator on Minikube

Why are we interested in Postgres on Kubernetes? I gave a talk last week on beginning the journey to getting PostgreSQL running on Kubernetes at the Buffalo Web Developers Database Meetup. There were examples on a simple deployment, configuring stateful sets, adding persistent volume claims and even a liveness probe. What I wanted to show

Chris Weibel Profile Image

Posted by:
Chris Weibel

Read More ➝
Cloud Foundry database replatforming from Postgres to MySQL

So you have a Cloud Foundry deployed with the `cf-release` codebaseand you have noticed that in the newer release Cloud Foundry switched to MySQL.And now you want to upgrade. But first you need to move from PostgreSQL so it will make your life easier for the future upgrades! The good thing is… It can be

Ramon Makkelie Profile Image

Posted by:
Ramon Makkelie

Read More ➝
Manual Backup of CCDB/UAADB on Cloud Foundry

For whatever reason you may want to make a database backup for uaadb or ccdb and copy the backup to a jumpbox or other server. The instructions below will walk through two options for performing the backups and getting the backup to a secondary server. Option 1 assumes the jumpbox cannot access the databases directly,

Chris Weibel Profile Image

Posted by:
Chris Weibel

Read More ➝
PGConf NYC 2015

I attended PGConf NYC 2015 on March 26-27. Going to conferences is awesome, in my opinion, because there is an amazing collection of minds available. Minds interested in the same topic you are, which in the nerdosphere(TM) is sometimes hard to come by. Before getting started discussing my favorite talks, I would like to send

Quintessence Anx Profile Image

Posted by:
Quintessence Anx

Read More ➝