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
  • 1
  • 2