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 […]