Contact Info

Folow us on social

Let’s hangout w/ Postgres people on Slack!

While casual discussions with Postgres users at  conference and/or online,  I came across this question for at least 3-4 times;  “Is there a Slack channel for Postgres?”  The answer was “No”. The idea of bringing up Slack channel was cooking in my mind for a long time but i did not have time to execute it! Now, I have […]

Postgres Replication Slot & pg_basebackup

On #postgresql IRC channel, someone was having problem bringing up standby database server from backups taken using pg_basebackup and recovery.conf was configured to use replication slot. The reporter was following  below steps: Set max_replication_slots=5, wal_keep_segments=0 and restart primary database create replication slot : SELECT * FROM pg_create_physical_replication_slot(‘standby’) Call pg_basebackup -D – -Ft | bzip2 > backup.tar.bz2 copy backup.tar.bz2 to standby […]

pgbadger log analysis for Postgres RDS instances

Last year, I have presented on Postgres RDS in Amazon at couple of conferences but I haven’t got change to follow up on my experience working with RDS after them. If you aren’t  aware, I recently changed job & started working at WithMe,  a disruptive start-up that focuses on three primary solutions for commerce, including WithMe Business, Financial and […]

Postgres Replication using Replication Slots

Postgres 9.4 introduced an awesome feature Replication Slots. This allows you to implement Postgres replication without using any external archive management tools. Yesterday, I presented three hours long tutorial on “Out of the box Postgres 9.4 Replication using Replication slots” at PgCon (Postgres conference) in Ottawa,Canada. If you want to follow along slides with VM, you […]

Why should you consider upgrading Postgres again?

As title suggests,  if you are running Postgres in your environment, it is very important that you plan to upgrade Postgres with the latest announced release. I upgraded Postgres recently in last couple of weeks. Should I upgrade again? Why? Yes, you should plan to upgrade again. Postgres released data corruption and security bug fix release on May 22nd and […]

Postgres in Amazon RDS

Today, I presented on “Postgres in Amazon RDS” topic at Postgres Open Conference in Chicago. Here is the slide deck:

Preventing Human Errors in Postgres

Whenever discussion on Disaster Recovery Planning for the databases comes up, “Preventing & Recovering from Human Error” topic arises because human tends to make mistakes and engineers are humans 🙂  Having best DBAs around and with restrictions &  best practices/policies in-place,  you still can’t afford to ignore the fact – “an engineer could make mistake”. […]

Postgres Security & PGConf NYC 2014

As per my knowledge, I haven’t heard or attended  Postgres conference with dedicated “Security” track . Rarely, you find one or two talks about security over couple of Postgres conferences but  never a dedicated track !  It is  indisputable to say that  Security is one of the most critical areas to consider for selecting  database […]

Can Postgres 9.2 upgrade cause “Out of memory” error?

Earlier this week, we got an email from with the need of “a serious Postgres expert” to solve the problem they have been experiencing and blocker for number of projects at hand. They heard good things about OmniTI from technology clubs and communities in NYC. is an online charity that makes it easy for anyone to help students in need. […]

Postgres 9.2: monitoring temp files generation in real time

With other great new features, PostgreSQL 9.2 makes DBAs life easy by providing more metrics  in statistics collector views. Out of those , pg_stat_database caught my eyes because it provides a lot more details compare to Postgres 9.1 and other previous versions. Postgres 9.1 postgres=# \d pg_stat_database View “pg_catalog.pg_stat_database” Column | Type | Modifiers —————+————————–+———– datid | oid […]