PgConf.Russia 2016

• First aquaintance
• Fight with replication
• Partitioning and migration
• Cross data-center use
• v8, json, jsonb, jsquery
• Version upgrade

A backup is something that no Postgres deployments should go without as it gives the insurance to get back a deployment on its feet should a disaster strike.

In this talk we will discuss why backups are essential in any sane PostgreSQL deployments (this seems obvious) and what are the different options available to define and set up a good backup strategy. On top of that is discussed how the future of backups would need to be handled, particularly regarding differential backups that gain in popularity among users with large deployments.

Challenges and solutions found in documents dematerialization and bank cheque processing system used in the Bank of Brazil.