Django 2 by Example

Using PostgreSQL

Throughout this book, we have mostly used the SQLite database. SQLite is simple and quick to set up, but for a production environment you will need a more powerful database, such as PostgreSQL, MySQL, or Oracle. You already learned how to install PostgreSQL and set up a PostgreSQL database in Chapter 3, Extending Your Blog Application. If you need to install PostgreSQL, you can read the Installing PostgreSQL section of Chapter 3, Extending Your Blog Application.

Let's create a PostgreSQL user. Open the shell and run the following commands to create a database user:

su postgrescreateuser -dP educa

You will be prompted for a password and permissions you want to give to this user. Enter the desired password and permissions and ...