PostgreSQL: Setup on the Local Machine

Explore how to install and configure PostgreSQL on your local machine across different operating systems. Learn to customize the psql environment by setting variables and transaction behavior to improve interactive SQL query execution and error management.

We'll cover the following...

Setting up a local environment
The psqlrc setup
Transactions and psql behavior
Try it yourself

Setting up a local environment

We’re providing you with an execution environment with PostgreSQL running. If you want to later practice on your own machine, you will need a database server to play along with.

If you’re using MacOSX, check out Postgres App to install a PostgreSQL server and the psql tool.
For Windows, check this link.
If you’re mainly running Linux, you know what you’re doing already, right? Look at the PostgreSQL packages for Debian and Ubuntu and install the most recent version of PostgreSQL on your station so that you have ...