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
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 22.214.171.124/80 password hostnossl all all all reject
Good, so what all is going on here? Let's take a look at the first...
To see the complete version of this and more awesome articles become a superuser or login