Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Learning Heroku Postgres
  • Table Of Contents Toc
Learning Heroku Postgres

Learning Heroku Postgres

By : Patrick Rafael de Oliveira Espake
4.3 (4)
Buy this Book
close
close
Learning Heroku Postgres

Learning Heroku Postgres

4.3 (4)
By: Patrick Rafael de Oliveira Espake
Buy this Book

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.
Table of Contents (12 chapters)
close
close
close
Preface
Icon
Preface
Icon
What this book covers
Icon
What you need for this book
Icon
Who this book is for
Icon
Conventions
Icon
Reader feedback
Icon
Customer support
Lock Free Chapter
1
1. Getting Started with Heroku Postgres
Icon
1. Getting Started with Heroku Postgres
Icon
How does Heroku work?
Icon
Postgres supported versions
Icon
Choosing the right Heroku Postgres plan
Icon
Production-tier technical characterization
Icon
High availability
Icon
Self-test Questions
Icon
Summary
2
2. Heroku Toolbelt
Icon
2. Heroku Toolbelt
Icon
Signing up
Icon
Installing the Heroku Toolbelt
Icon
Logging in to Heroku
Icon
Deploying an application
Icon
The sample application source code
Icon
The dependencies file
Icon
Deploying the sample application
Icon
Visiting the sample application
Icon
Self-test questions
Icon
Summary
3
3. Postgres Add-on
Icon
3. Postgres Add-on
Icon
Local setup
Icon
Creating a new app
Icon
Adding the add-on and creating the first database
Icon
Heroku Postgres web interface
Icon
Using the Heroku client with Postgres
Icon
Connecting with Java
Icon
Connecting with Python
Icon
Connecting with Django
Icon
Connecting with Node.js
Icon
Connection permissions
Icon
Multiple schemas
Icon
External connections
Icon
Connecting to databases from outside Heroku
Icon
Monitoring and logging
Icon
Removing the add-on
Icon
Self-test Questions
Icon
Summary
4
4. PG Backups
Icon
4. PG Backups
Icon
Plans
Icon
Importing in Heroku Postgres
Icon
Exporting databases
Icon
Downloading the backup
Icon
Restoring to local database
Icon
Removing the add-on
Icon
Self-test Questions
Icon
Summary
5
5. Dataclips
Icon
5. Dataclips
Icon
Creating dataclips
Icon
Sharing dataclips
Icon
Interacting with dataclips
Icon
Dataclips security
Icon
Limitations and additional settings
Icon
Self-test questions
Icon
Summary
6
6. Rollback, Followers, and Forks
Icon
6. Rollback, Followers, and Forks
Icon
Heroku Postgres rollback
Icon
Heroku Postgres follower databases
Icon
Heroku Postgres forking databases
Icon
Self-test questions
Icon
Summary
7
7. Understanding Log Statements and Common Errors
chevron up
Icon
7. Understanding Log Statements and Common Errors
Icon
Log statements
Icon
Common errors
Icon
Metrics logs
Icon
Self-test questions
Icon
Summary
8
8. Extensions, PostGIS, Full Text Search Dictionaries, Data Caching, and Tuning
Icon
8. Extensions, PostGIS, Full Text Search Dictionaries, Data Caching, and Tuning
Icon
Heroku Postgres extensions
Icon
Data types
Icon
Statistics
Icon
Languages
Icon
Full text search dictionaries
Icon
Data caching
Icon
Setting up PostGIS
Icon
Database tuning
Icon
Automatic vacuuming
Icon
Performance analysis
Icon
Self-test Questions
Icon
Summary
9
A. Keyword List
Icon
A. Keyword List
10
B. Self-test Answers
Icon
Chapter 1: Getting Started with Heroku Postgres
Icon
Chapter 2: Heroku Toolbelt
Icon
Chapter 3: Postgres Add-on
Icon
Chapter 4: PG Backups
Icon
Chapter 5: Dataclips
Icon
Chapter 6: Rollback, Followers, and Forks
Icon
Chapter 7: Understanding Log Statements and Common Errors
Icon
Chapter 8: Extensions, PostGIS, Full Text Search Dictionaries, Data Caching, and Tuning
11
Index
Icon
Index

Common errors

There are a number of common errors that can be easily identified through the logs. Understanding these errors and analyzing can help you in the process of continuous database improvement.

Then you will understand the most common ones so that you can take the necessary action in order to solve them.

LOG: long duration

Queries that take longer than 2 seconds are logged automatically so that you can identify and optimize your code. These logs are generated in the following format:

[8-2] g0afa5bjht [GOLD] LOG: duration: 63.697 ms statement: SELECT "courses".* FROM "courses"...

If there are large numbers of these logs, probably your application has performance problems. A good recommendation is to try to reduce the execution time of your queries by 10 ms. You can achieve this optimization by adding indexes or using the EXPLAIN command from PostgreSQL to understand the performance issues in your query.

LOG: unexpected EOF on client connection

This error occurs when...

CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Learning Heroku Postgres
End of Section 7
Next Section
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful
Order Page Read Now

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon