Book Image

Learning Heroku Postgres

By : Patrick Rafael de Oliveira Espake
Book Image

Learning Heroku Postgres

By: Patrick Rafael de Oliveira Espake

Overview of this book

Related Content you might be interested in

Current Title:

Small book image
Learning Heroku Postgres
Patrick Rafael de Oliveira Espake
Feb, 2015 | 164 pages
No titles found
Table of Contents (17 chapters)
Learning Heroku Postgres
Learning Heroku Postgres
Credits
Credits
About the Author
About the Author
About the Reviewers
About the Reviewers
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
Getting Started with Heroku Postgres
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
2
Heroku Toolbelt
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
3
Postgres Add-on
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
4
PG Backups
PG Backups
Plans
Importing in Heroku Postgres
Exporting databases
Downloading the backup
Restoring to local database
Removing the add-on
Self-test Questions
Summary
5
Dataclips
Dataclips
Creating dataclips
Sharing dataclips
Interacting with dataclips
Dataclips security
Limitations and additional settings
Self-test questions
Summary
6
Rollback, Followers, and Forks
Rollback, Followers, and Forks
Heroku Postgres rollback
Heroku Postgres follower databases
Heroku Postgres forking databases
Self-test questions
Summary
7
Understanding Log Statements and Common Errors
Understanding Log Statements and Common Errors
Log statements
Common errors
Metrics logs
Self-test questions
Summary
8
Extensions, PostGIS, Full Text Search Dictionaries, Data Caching, and Tuning
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
Keyword List
Keyword List
Self-test Answers
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
Index

Restoring to local database

A restore operation uses the pg_restore tool. It is installed by default during the PostgreSQL installation locally. For restoring the database, enter the following command:

$ pg_restore --verbose --clean --no-acl --no-owner -h localhost -U your-db-username -d your-database-name latest.dump
Previous Section
End of Section 6
Next Section