opendbteam workspace

opendbteam workspace
opendbteam workspace

Thursday, November 26, 2015

Little #reminder on #pg_stat_activity

Ever wondered who was connected to your database? What the PID of the connection you want to terminate is? Well search no more and read the nicely packaged reminder on the pg_stat_activity from Alexey Lesovsky: Introduction to pg_stat_activity

Monday, November 16, 2015

Tuesday, November 10, 2015

A little refresher and #BestPractice before switching to #PostgreSQL

It seems to be obvious to follow these steps when switching to PostgreSQL but these mistakes are often made, leading to crisis and often very expensive support procedures. As such let's delve into this nicely crafted reminder from Enterprisedb: Top 10 Steps to a Smoother Postgres Deployment

Thursday, November 5, 2015

Understanding #PostgreSQL: #replication_slots and #pg_basebackup

Since version 9.4, a lot of things have changed: new options, new default values, new workarounds. In this article Denish Patel takes a look at replication_slots and pg_basebackup which does not yet support it (don't worry, it has been committed to 9.6). More details @ POSTGRES REPLICATION SLOT & PG_BASEBACKUP