3. Postgres Add-on | Learning Heroku Postgres

Sign In Start Free Trial

Book Overview & Buying
Table Of Contents
Feedback & Rating

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

Customer Reviews

4.3 (4)

5 star

25%

4 star

75%

3 star

0%

2 star

0%

1 star

0%

Local setup

You need to install PostgreSQL on your computer; this installation is recommended because some commands of the Postgres add-on require PostgreSQL to be installed. Besides that, it's a good idea for your development database to be similar to your production database; this avoids problems between these environments.

Next, you will learn how to set up PostgreSQL on Mac OS X, Windows, and Linux. In addition to pgAdmin, this is the most popular and rich feature in PostgreSQL's administration and development platform.

The versions recommended for installation are PostgreSQL 9.4.0 and pgAdmin 1.20.0, or the latest available versions.

Setting up PostgreSQL on Mac OS X

The Postgres.app application is the simplest way to get started with PostgreSQL on Mac OS X, it contains many features in a single installation package:

PostgreSQL 9.4.0
PostGIS 2.1.4
Procedural languages: PL/pgSQL, PL/Perl, PL/Python, and PLV8 (JavaScript)
Popular extensions such as hstore, uuid-ossp, and others
Many command-line...

Visually different images

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