Hello and welcome. For this video, we are focusing on some in depth tuning of our PostgreSQL systems. Specifically, we will be dealing with configuration in our postgresql.conf and pg_hba.conf files.

First, we need to take an in depth look at pg_hba.conf. We already know the basic idea behind this file. It is the location where client authentication is handled in PostgreSQL. We use it to define very specifically who can access our Postgres instance and which databases within that instance they are allowed to work with specifically. To better understand this, let's take a more in depth look at the pg_hba.conf file and try writing some example connections.

video showing the opening of pg_hba.conf

Ok, now let's write some example connections.

# my fake app host my_awesome_app samy 555.0.543.12 md5 local all jane 127.0.0.1 trust hostssl another_app_db irwin 52.12.0.2/80 password hostnossl all all all reject

Good, so what all is going on here? Let's take a look at the first...