Enterprise Grade Deployment and Security with PostgreSQL
Check out http://www.pgconf.us/2015/event/87/ for the full talk details.
The talk will include how we are using PostgreSQL in the production environment at Inmobi . Following are the key-points:
* PostgreSQL as the main transactional master DB with 99% uptime
* Automated way to implement in production (with puppet)
* Replication via cascaded SR in multiple data center
* Readonly DB load balancing on multiple nodes in each data centre
* Pgbouncer pooling
*Security control via pg_hba
*Customer Interface reporting db