Database Reference
In-Depth Information
Summary
In this chapter, you learned how to configure your local environment to work with Post-
greSQL and pgAdmin. Besides that, you have also understood how to install Heroku Post-
gres in your application.
In addition, you have understood that the first database is created automatically when the
Heroku Postgres add-on is installed in your application and there are several PostgreSQL
databases as well. You also learned that the great majority of tasks can be performed in two
ways: via the Heroku Client and via the Heroku dashboard.
You have also learned that Heroku Client is a very powerful tool to work with PostgreSQL;
it provides a set of useful commands such as
pg:info
,
pg:psql
,
pg:push
,
pg:pull
,
pg:ps
,
pg:kill
,
pg:killall
,
pg:promote
,
pg:credentials
, and
pg:reset
.
You also looked at how to connect to your PostgreSQL database using programming and
frameworks supported by Heroku, and learned how to connect to your database using
pgAdmin.
Finally, you learned how to use a database that isn't hosted on Heroku application, and
about monitoring, information logging, and removing the Heroku Postgres add-on.
In the next chapter, we will learn about backups, how to generate backups, and importing
and exporting databases. In addition, you will also learn about data security and how to up-
grade databases.
