3. Postgres Add-on | Learning Heroku Postgres

Sign In Start Free Trial

Book Overview & Buying
Table Of Contents

Learning Heroku Postgres

By : Patrick Rafael de Oliveira Espake

4.3 (4)

Learning Heroku Postgres

4.3 (4)

By: Patrick Rafael de Oliveira Espake

Overview of this book

Learning Heroku Postgres is targeted at developers and database admins. Even if you're new to Heroku Postgres, you'll be able to master both the basic as well as advanced features of Heroku Postgres. Since Heroku Postgres is incredibly user-friendly, no previous experience in computer coding or programming is required.

Preface

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Free Chapter

1. Getting Started with Heroku Postgres

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

2. Heroku Toolbelt

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

3. Postgres Add-on

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

4. PG Backups

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

5. Dataclips

5. Dataclips

Creating dataclips

Sharing dataclips

Interacting with dataclips

Dataclips security

Limitations and additional settings

Self-test questions

Summary

6. Rollback, Followers, and Forks

6. 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

7. 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

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

A. Keyword List

A. Keyword List

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

Index

Creating a new app

Many features in Heroku can be implemented in two different ways; the first is via the Heroku client, which is installed through the Heroku Toolbelt, and the other is through the web Heroku dashboard.

In this section, you will learn how to use both of them.

Via the Heroku dashboard

Access the website https://dashboard.heroku.com and login. After that, click on the plus sign at the top of the dashboard to create a new app and the following screen will be shown:

Creating an app

In this step, you should provide the name of your application. In the preceding example, it's learning-heroku-postgres-app. You can choose a name you prefer. Select which region you want to host it on; two options are available: United States or Europe.

Note

Heroku doesn't allow duplicated names for applications; each application name supplied is global and, after it has been used once, it will not be available for another person. It can happen that you choose a name that is already being used. In this case...

CONTINUE READING

83

Tech Concepts

36

Programming languages

73

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

Learning Heroku Postgres

Search

Your notes and bookmarks