AWS Aurora Postgres, Not A Great First Impression

AWS Aurora Postgres, not a great first impression

Recently we had a customer facing some memory issues with an Aurora PostgreSQL. What was happening is that while loading data or creating GiST indexes they got the following error :2018-01-04 14:03:06 UTC:172.31.45.250(35508):root@test:[20457]:ERROR:  out of memory2018-01-04 14:03:06 UTC:172.31.45.250(35508):root@test:[20457]:DETAIL:  Failed on…

Read More

PostgreSQL on ZFS

What is ZFS. (a paste from wikipedia)ZFS is a combined file system and logical volume manager designed by Sun Microsystems. The features of ZFS include protection against data corruption, support for high storage capacities, efficient data compression, integration of the concepts of filesystem and volume management, snapshots and copy-on-write clones, continuous integrity…

Read More
Cannot Drop The Database [database_name] Because It Is Being Used For Replication

Cannot drop the database [database_name] because it is being used for replication

Cannot drop the database [database_name] because it is being used for replication

If you ever found yourself in such a bizzare situation, read how to overcome this. Recently I was working in my test environment, trying several things regarding replication. After numerous setups, removals, backups, restores etc, I found mysefl in a situation where:

Read More