Downloaded 13 times
Uploaded byAaron Thul
Drinkers guide to PostgreSQL
This document is a drinkers guide to PostgreSQL that provides reasons why one might need a drink related to working with PostgreSQL. Some reasons include someone telling you that PostgreSQL is hard to install, having issues with pg_hba.conf configuration, bloating the database, being forced to use an iSCSI solution, having patches rejected by Tom Lane, accidentally shutting down or killing the production database, discovering that the database has 100,000 tables, issues with pg_upgrade, having to use MySQL, encountering exceptions, and giving lightning talks. The guide concludes by thanking the audience and providing contact details for the author.
Drinkers guide to PostgreSQL
- 1. The drinkers guideto PostgreSQL Aaron Thul I am just here to drink and don’t really know anything
- 3. Do we needto • Application developers • Managers • Our own mistakes • Do we really need a reason???
- 4. Someone told youPg was hard to install
- 5. Someone told youPg was hard to install
- 6.
- 7.
- 8. Someone is havinga pg_hba.conf problem
- 9. Someone is havinga pg_hba.conf problem
- 10. Someone bloated the bejeebersout of the database
- 11. Someone bloated the bejeebersout of the database
- 12. Management forced an iSCSI solution
- 13. Management forced an iSCSI solution
- 14. Tom Lane rejectedyour patch
- 15. Tom Lane rejectedyour patch
- 16. Someone Shutdown/ killed production
- 17. Someone Shutdown/ killed production
- 18. You realize yourDB has 100,000 tables
- 19. You realize yourDB has 100,000 tables
- 20. You tried touse Pg_Upgrade
- 21. You tried touse Pg_Upgrade
- 22. You had touse MySQL
- 23. You had touse MySQL
- 24.
- 25.
- 26.
- 27. Lightening Talk • One bottle of Scotch
- 28. Thank you • AaronThul • aaron@chasingnuts.com • @aaronthul on Twitter • AaronThul on IRC