Cargando…
Learning heroku postgres : efficiently design, implement, and manage a successful PostgreSQL database with Heroku /
Annotation
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Birmingham, England :
Packt Publishing Ltd,
2015.
|
| Colección: | Professional expertise distilled
|
| Temas: | |
| Acceso en línea: | Texto completo |
Tabla de Contenidos:
- Cover; Copyright; Credits; About the Author; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Getting Started with Heroku Postgres; How does Heroku work?; Heroku Dashboard and Heroku Toolbelt; Deploying your applications; Heroku architecture; HTTP routing; Dyno Manager; Config vars; Understanding the Dynos; Workers; Add-ons; Logplex; Heroku API; Postgres supported versions; Choosing the right Heroku Postgres plan; Shared features; Production-tier technical characterization; High availability; Self-test Questions; Summary; Chapter 2: Heroku Toolbelt; Signing up
- Installing the Heroku ToolbeltLogging 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; Setting up PostgreSQL on Mac OS X; Setting up PostgreSQL on Windows; Setting up PostgreSQL on Linux; Creating a local database; Creating a new app; Via the Heroku dashboard; Via the Heroku client; Adding the add-on and creating the first database; Adding the Heroku Postgres add-on; Via the Heroku add-ons gallery
- Via the Heroku clientCreating the first database; Heroku Postgres web interface; Using the Heroku client with Postgres; The pg:info command; The pg:psql command; The pg:push command; The pg:pull command; The pg:ps command; The pg:kill command; The pg:killall command; The pg:promote command; The pg:credentials command; The pg:reset command; Connecting with Java; JDBC; Spring/XML; Connecting with Ruby; Connecting with Python; Connecting with Django; Connecting with Node.js; Connection permissions; Multiple schemas; External connections; Connecting to databases from outside Heroku
- Monitoring and loggingRemoving the add-on; Self-test Questions; Summary; Chapter 4: PG Backups; Plans; Installing the add-on; Via the Heroku client; Via the web interface; Changing the plan; Creating a backup; Listing backups; Via the Heroku client; Via the web interface; Downloading a backup; Deleting backups; Restoring from a backup; Importing databases; Importing to Heroku Postgres; Exporting databases; Downloading the backup; Restoring to local database; Removing the add-on; Via the Heroku client; Via the web interface; Self-test Questions; Summary; Chapter 5: Dataclips
- Creating dataclipsSharing dataclips; Interacting with dataclips; Data refresh; Dataclips security; Limitations and additional settings; Self-test questions; Summary; Chapter 6: Rollback, Followers, and Forks; Heroku Postgres rollback; Checking the rollback feature; Available period; Creating a rollback database; Promote a rollback database; Deprovisioning a rollback database; Heroku Postgres follower databases; Creating and managing follower databases; Unfollow the main database; Upgrade the database plan with follower; High availability with followers; Heroku Postgres forking databases