coverpage
Learning Heroku Postgres
Credits
About the Author
About the Reviewers
www.PacktPub.com
Support files eBooks discount offers and more
Preface
What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
Chapter 1. Getting Started with Heroku Postgres
How does Heroku work?
Postgres supported versions
Choosing the right Heroku Postgres plan
Production-tier technical characterization
High availability
Self-test Questions
Summary
Chapter 2. Heroku Toolbelt
Signing up
Installing the Heroku Toolbelt
Logging in to Heroku
Deploying an application
The sample application source code
The dependencies file
Deploying the sample application
Visiting the sample application
Self-test questions
Summary
Chapter 3. Postgres Add-on
Local setup
Creating a new app
Adding the add-on and creating the first database
Heroku Postgres web interface
Using the Heroku client with Postgres
Connecting with Java
Connecting with Python
Connecting with Django
Connecting with Node.js
Connection permissions
Multiple schemas
External connections
Connecting to databases from outside Heroku
Monitoring and logging
Removing the add-on
Self-test Questions
Summary
Chapter 4. PG Backups
Plans
Importing in Heroku Postgres
Exporting databases
Downloading the backup
Restoring to local database
Removing the add-on
Self-test Questions
Summary
Chapter 5. Dataclips
Creating dataclips
Sharing dataclips
Interacting with dataclips
Dataclips security
Limitations and additional settings
Self-test questions
Summary
Chapter 6. Rollback Followers and Forks
Heroku Postgres rollback
Heroku Postgres follower databases
Heroku Postgres forking databases
Self-test questions
Summary
Chapter 7. Understanding Log Statements and Common Errors
Log statements
Common errors
Metrics logs
Self-test questions
Summary
Chapter 8. Extensions PostGIS Full Text Search Dictionaries Data Caching and Tuning
Heroku Postgres extensions
Data types
Statistics
Languages
Full text search dictionaries
Data caching
Setting up PostGIS
Database tuning
Automatic vacuuming
Performance analysis
Self-test Questions
Summary
Appendix A. Keyword List
Appendix B. Self-test Answers
Chapter 1: Getting Started with Heroku Postgres
Chapter 2: Heroku Toolbelt
Chapter 3: Postgres Add-on
Chapter 4: PG Backups
Chapter 5: Dataclips
Chapter 6: Rollback Followers and Forks
Chapter 7: Understanding Log Statements and Common Errors
Chapter 8: Extensions PostGIS Full Text Search Dictionaries Data Caching and Tuning
Index
更新时间：2021-07-23 20:48:51
完结共104章
倒序